Re: greatest/least semantics different between oracle and postgres

From: Ben <bench(at)silentmedia(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "PostgreSQL General ((EN))" <pgsql-general(at)postgresql(dot)org>
Subject: Re: greatest/least semantics different between oracle and postgres
Date: 2007-06-30 05:18:07
Message-ID: BEF0BBEC-B458-4EE9-853A-608BCB096B9C@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message paul rivers 2007-06-30 05:29:45 Re: greatest/least semantics different between oracle and postgres
Previous Message Aly Dharshi 2007-06-30 05:08:02 Sun Cluster and PGSQL