Re: greatest/least semantics different between oracle and postgres - Mailing list pgsql-general

From Andrej Ricnik-Bay
Subject Re: greatest/least semantics different between oracle and postgres
Date
Msg-id b35603930706292047k45dc34e1s6715c77b6fe7e0fd@mail.gmail.com
Whole thread Raw
In response to greatest/least semantics different between oracle and postgres  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: greatest/least semantics different between oracle and postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 6/30/07, Bruno Wolff III <bruno@wolff.to> wrote:
> The following is just FYI.
> I was recently doing some stuff with greatest() on oracle (9.2.0.8.0) and
> noticed that it returned null if ANY of the arguments were null. Out of
> curiosity I checked postgres' definition of that function and found that it
> returns null only if ALL of the arguments are null.
W/o knowing the SQL standard (just from what I'd perceive
as sensible) I'd say Oracle is broken. :}


-- Cheers,
   Andrej

pgsql-general by date:

Previous
From: Jan de Visser
Date:
Subject: Re: Looking for help regarding getting the latest inserted sequence value.
Next
From: Tom Lane
Date:
Subject: Re: greatest/least semantics different between oracle and postgres