diff options
| author | Bruce Momjian <bruce@momjian.us> | 2011-10-04 21:47:07 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2011-10-04 21:47:51 -0400 |
| commit | 9d23d7cdafb3540aa2de9310c7f1afee87dfc2f2 (patch) | |
| tree | dfb3759b5008e6f4c578028588031aa4af7c0dfa /doc/src | |
| parent | 41e461d36fb1ef78494429f28ea4b72c759f419d (diff) | |
| download | postgresql-9d23d7cdafb3540aa2de9310c7f1afee87dfc2f2.tar.gz postgresql-9d23d7cdafb3540aa2de9310c7f1afee87dfc2f2.zip | |
Explain COALESCE example in the docs.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 0b6a109432e..2f307c2b121 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -10015,6 +10015,8 @@ SELECT ... WHERE CASE WHEN x <> 0 THEN y/x > 1.5 ELSE false END; <programlisting> SELECT COALESCE(description, short_description, '(none)') ... </programlisting> + This returns <varname>description</> if it is not null, or + <varname>short_description</> if it is not null, or <literal>(none)</>. </para> <para> |