Hi,
On Sun, 27 Mar 2005, Enrico Weigelt wrote:
Hi folks,
is there an function returning true if the argument is null or
zero (just to make some queries more concise). Of course its
trivial to implement as SQL function, but if postgresql already
provides such a function, I would prefer using it.
Lookup the documentation on COALESCE()
http://www.postgresql.org/docs/current/static/functions-conditional.html
9.13.2. COALESCE
Greetings
Christian
--
Christian Kratzer [EMAIL PROTECTED]
CK Software GmbH http://www.cksoft.de/
Phone: +49 7452 889 135 Fax: +49 7452 889 136
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]