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

From Bruno Wolff III
Subject greatest/least semantics different between oracle and postgres
Date
Msg-id 20070629224135.GA2150@wolff.to
Whole thread Raw
Responses Re: greatest/least semantics different between oracle and postgres  ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>)
Re: greatest/least semantics different between oracle and postgres  ("Pavel Stehule" <pavel.stehule@gmail.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Oisin Glynn
Date:
Subject: Re: [pgsql] Simple backup utility like mysqldump?
Next
From: Tom Lane
Date:
Subject: Re: varchar(n) VS text