PostgreSQL 8.3 Documentation....................................................................................215 9.16.2. COALESCE ............................................................................................... failure: SELECT ... WHERE CASE WHEN x <> 0 THEN y/x > 1.5 ELSE false END; 9.16.2. COALESCE COALESCE(value [, ...]) The COALESCE function returns the first of its arguments that is not null. Null is returned when data is retrieved for display, for example: SELECT COALESCE(description, short_description, ’(none)’) ... Like a CASE expression, COALESCE will not evaluate arguments that are not needed to determine0 码力 | 2143 页 | 4.58 MB | 1 年前3- PostgreSQL 8.3 Documentation....................................................................................203 9.16.2. COALESCE ............................................................................................... CASE WHEN x <> 0 THEN y/x > 1.5 ELSE false END; 9.16.2. COALESCE COALESCE(value [, ...]) 204 Chapter 9. Functions and Operators The COALESCE function returns the first of its arguments that is not when data is retrieved for display, for example: SELECT COALESCE(description, short_description, ’(none)’) ... Like a CASE expression, COALESCE will not evaluate arguments that are not needed to determine0 码力 | 2015 页 | 4.54 MB | 1 年前3
- PostgreSQL 8.4 Documentation....................................................................................218 9.16.2. COALESCE ............................................................................................... during query execution might still be evaluated during query planning. 9.16.2. COALESCE COALESCE(value [, ...]) The COALESCE function returns the first of its arguments that is not null. Null is returned when data is retrieved for display, for example: SELECT COALESCE(description, short_description, ’(none)’) ... Like a CASE expression, COALESCE only evaluates the arguments that are needed to determine0 码力 | 2224 页 | 5.05 MB | 1 年前3
- PostgreSQL 8.4 Documentation....................................................................................232 9.16.2. COALESCE ............................................................................................... during query execution might still be evaluated during query planning. 9.16.2. COALESCE COALESCE(value [, ...]) The COALESCE function returns the first of its arguments that is not null. Null is returned when data is retrieved for display, for example: SELECT COALESCE(description, short_description, ’(none)’) ... Like a CASE expression, COALESCE only evaluates the arguments that are needed to determine0 码力 | 2371 页 | 5.09 MB | 1 年前3
- PostgreSQL 9.0 Documentation....................................................................................240 9.16.2. COALESCE ............................................................................................... if it’s within a CASE arm that would never be entered at run time. 9.16.2. COALESCE COALESCE(value [, ...]) The COALESCE function returns the first of its arguments that is not null. Null is returned when data is retrieved for display, for example: SELECT COALESCE(description, short_description, ’(none)’) ... Like a CASE expression, COALESCE only evaluates the arguments that are needed to determine0 码力 | 2561 页 | 5.55 MB | 1 年前3
- PostgreSQL 9.0 Documentation....................................................................................224 9.16.2. COALESCE ............................................................................................... if it’s within a CASE arm that would never be entered at run time. 9.16.2. COALESCE COALESCE(value [, ...]) The COALESCE function returns the first of its arguments that is not null. Null is returned when data is retrieved for display, for example: SELECT COALESCE(description, short_description, ’(none)’) ... Like a CASE expression, COALESCE only evaluates the arguments that are needed to determine0 码力 | 2401 页 | 5.50 MB | 1 年前3
- PostgreSQL 9.1.24 Documentation
....................................................................................233 9.16.2. COALESCE ............................................................................................... if it’s within a CASE arm that would never be entered at run time. 9.16.2. COALESCE COALESCE(value [, ...]) The COALESCE function returns the first of its arguments that is not null. Null is returned when data is retrieved for display, for example: SELECT COALESCE(description, short_description, ’(none)’) ... Like a CASE expression, COALESCE only evaluates the arguments that are needed to determine0 码力 | 2667 页 | 6.57 MB | 1 年前3
- PostgreSQL 9.1 Documentation....................................................................................250 9.16.2. COALESCE ............................................................................................... if it’s within a CASE arm that would never be entered at run time. 9.16.2. COALESCE COALESCE(value [, ...]) The COALESCE function returns the first of its arguments that is not null. Null is returned when data is retrieved for display, for example: SELECT COALESCE(description, short_description, ’(none)’) ... Like a CASE expression, COALESCE only evaluates the arguments that are needed to determine0 码力 | 2836 页 | 6.62 MB | 1 年前3
- PostgreSQL 9.3.25 Documentation....................................................................................252 9.17.2. COALESCE ............................................................................................... if it’s within a CASE arm that would never be entered at run time. 9.17.2. COALESCE COALESCE(value [, ...]) The COALESCE function returns the first of its arguments that is not null. Null is returned substitute a default value for null values when data is retrieved for display, for example: SELECT COALESCE(description, short_description, ’(none)’) ... This returns description if it is not null, otherwise0 码力 | 3002 页 | 7.47 MB | 1 年前3
- PostgreSQL 9.3 Documentation....................................................................................268 9.17.2. COALESCE ............................................................................................... if it’s within a CASE arm that would never be entered at run time. 9.17.2. COALESCE COALESCE(value [, ...]) The COALESCE function returns the first of its arguments that is not null. Null is returned substitute a default value for null values when data is retrieved for display, for example: SELECT COALESCE(description, short_description, ’(none)’) ... This returns description if it is not null, otherwise0 码力 | 3183 页 | 7.53 MB | 1 年前3
共 40 条
- 1
- 2
- 3
- 4