Re: Auomatic numbering, replacing nulls and IF

From: Thomas Lockhart <thomas(at)fourpalms(dot)org>
To: luke(at)itsd(dot)co(dot)nz
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Auomatic numbering, replacing nulls and IF
Date: 2002-03-20 15:14:19
Message-ID: 3C98A74B.CEC9C0FA@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

...
> 2) The ISNULL function in both Oracle and MS-SQL takes 2 numbers and returns
> the second if the first is null, otherwise it returns the first. ISNULL in
> Postgres seems to be something quite different. Before I go writing my own
> function to do it, is there one already?

Look at COALESCE(). Does ISNULL() actually do something different in
Oracle and M$SQL? I'm curious because our definition conforms to the
SQL9x standard, and those databases claim to generally conform also.

- Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Pfau 2002-03-20 15:20:38 Re: Visual display tool?
Previous Message Jean-Michel POURE 2002-03-20 14:53:12 Re: plpgsql function docs