Re: Problem -Postgre sql - Mailing list pgsql-sql

From Michael Glaesemann
Subject Re: Problem -Postgre sql
Date
Msg-id E80C316D-C8FB-457A-8032-ABF6A4A36AB0@myrealbox.com
Whole thread Raw
In response to Problem -Postgre sql  ("Vikas J" <vikas.jadhav@codecindia.com>)
List pgsql-sql
[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





pgsql-sql by date:

Previous
From: "Stewart Ben (RBAU/EQS4) *"
Date:
Subject: Re: Problem while using start transaction ans commit;
Next
From: Michael Glaesemann
Date:
Subject: Re: Query information needed