Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 29 Jun 2007 22:18:07 -0700
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.
- Follow-Ups:
- Re: greatest/least semantics different between oracle and postgres
- From: Tom Lane
- Re: greatest/least semantics different between oracle and postgres
- From: paul rivers
- Re: greatest/least semantics different between oracle and postgres
- References:
- greatest/least semantics different between oracle and postgres
- From: Bruno Wolff III
- Re: greatest/least semantics different between oracle and postgres
- From: Andrej Ricnik-Bay
- Re: greatest/least semantics different between oracle and postgres
- From: Tom Lane
- greatest/least semantics different between oracle and postgres
- Prev by Date: Sun Cluster and PGSQL
- Next by Date: Re: greatest/least semantics different between oracle and postgres
- Previous by thread: Re: greatest/least semantics different between oracle and postgres
- Next by thread: Re: greatest/least semantics different between oracle and postgres
- Indexes: