Re: Auomatic numbering, replacing nulls and IF - Mailing list pgsql-general

From Thomas Lockhart
Subject Re: Auomatic numbering, replacing nulls and IF
Date
Msg-id 3C98A74B.CEC9C0FA@fourpalms.org
Whole thread Raw
In response to Auomatic numbering, replacing nulls and IF  ("Pestilence" <me@work.com>)
List 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

pgsql-general by date:

Previous
From: "Tom Pfau"
Date:
Subject: Re: Visual display tool?
Next
From: "Peter Darley"
Date:
Subject: Re: Visual display tool?