greatest/least semantics different between oracle and postgres

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: pgsql-general(at)postgresql(dot)org
Subject: greatest/least semantics different between oracle and postgres
Date: 2007-06-29 22:41:35
Message-ID: 20070629224135.GA2150@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-06-30 00:09:58 Re: varchar(n) VS text
Previous Message Oisin Glynn 2007-06-29 22:14:48 Re: [pgsql] Simple backup utility like mysqldump?