[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