Re: greatest/least semantics different between oracle and postgres

From: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: greatest/least semantics different between oracle and postgres
Date: 2007-06-30 04:27:12
Message-ID: b35603930706292127u54938341q49a057f57ce9e793@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 6/30/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 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?
But in min/max scenarios NULL values are simply ignored, too,
no?

> regards, tom lane
Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2007-06-30 04:57:55 Re: greatest/least semantics different between oracle and postgres
Previous Message Tom Lane 2007-06-30 04:15:42 Re: greatest/least semantics different between oracle and postgres