Postgres Pro
Downloads
Home   >   mailing lists

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

From Ben
Subject Re: greatest/least semantics different between oracle and postgres
Date
Msg-id BEF0BBEC-B458-4EE9-853A-608BCB096B9C@silentmedia.com
Whole thread Raw
In response to Re: greatest/least semantics different between oracle and postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: greatest/least semantics different between oracle and postgres  ("paul rivers" <rivers.paul@gmail.com>)
Re: greatest/least semantics different between oracle and postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
On Jun 29, 2007, at 9:15 PM, Tom Lane wrote:

> Hmm ... I fear Oracle's behavior is more correct, because if any
> argument is null (ie, unknown), then who can say what the greatest or
> least value is?  It's unknown (ie, null).  But I suspect our behavior
> is more useful.  Comments?

I agree with you. I don't know what the spec says, but it seems clear
Oracle is doing the proper thing and Postgres is doing the useful thing.

pgsql-general by date:

Previous
From: Aly Dharshi
Date:
Subject: Sun Cluster and PGSQL
Next
From: "paul rivers"
Date:
Subject: Re: greatest/least semantics different between oracle and postgres