Re: [SQL] Problem -Postgre sql

2005-10-19 Thread Muralidharan Ramakrishnan
COALESCE( , )   Vikas J <[EMAIL PROTECTED]> wrote: Hi I want to know substitute function for sql server ISNULL() function in postgre   Regards,Vikas Jadhav Codec Communication Pvt. Ltd.Swargate, Pune.Ph: 020-2422 1460/70 (Ext 37)Email: [EMAIL PROTECTED] Yahoo! India Matrimony: Find your pa

Re: [SQL] Problem -Postgre sql

2005-10-18 Thread Chris Travers
Correct me if I am wrong, but isn't COALESCE standard in this way? Best Wishes, Chris Travers Metatron Technology Consulting Michael Glaesemann wrote: [Please do not email me directly. Please post to the list so others may help and benefit from the discussion.] On Oct 19, 2005, at 14:30 , V

Re: [SQL] Problem -Postgre sql

2005-10-18 Thread Michael Glaesemann
[Please do not email me directly. Please post to the list so others may help and benefit from the discussion.] On Oct 19, 2005, at 14:30 , Vikas J wrote: IsNull in sql server has syntax like isnull(column,substitute) if "column" is null it shows value of "substitute". That can be achieved

Re: [SQL] Problem -Postgre sql

2005-10-18 Thread Michael Fuhr
On Tue, Oct 11, 2005 at 12:50:49PM +0530, Vikas J wrote: > I want to know substitute function for sql server ISNULL() function in postgre If you look in the index of the PostgreSQL documentation you'll find an entry for ISNULL: http://www.postgresql.org/docs/8.0/interactive/bookindex.html If Pos

Re: [SQL] Problem -Postgre sql

2005-10-18 Thread Michael Glaesemann
[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

[SQL] Problem -Postgre sql

2005-10-18 Thread Vikas J
Hi I want to know substitute function for sql server ISNULL() function in postgre   Regards,Vikas Jadhav Codec Communication Pvt. Ltd.Swargate, Pune.Ph: 020-2422 1460/70 (Ext 37)Email: [EMAIL PROTECTED]