[It's PostgreSQL, Postgres, or pgsql. It's never "postgre"]
On Oct 11, 2005, at 16:20 , Vikas J wrote:
Hi
I want to know substitute function for sql server ISNULL() function
in postgre
I'm not quite sure what the ISNULL() function does in SQL Server, but
it sounds like it might be similar to either COALESCE or the IS NULL
expression.
These pages might help you:
COALESCE
http://www.postgresql.org/docs/8.0/interactive/functions-
conditional.html#AEN12056
IS NULL
http://www.postgresql.org/docs/8.0/interactive/functions-comparison.html
Hope this helps.
Michael Glaesemann
grzm myrealbox com
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
