Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 29 Jun 2007 17:41:35 -0500
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.
- Follow-Ups:
- Re: greatest/least semantics different between oracle and postgres
- From: Pavel Stehule
- Re: greatest/least semantics different between oracle and postgres
- From: Andrej Ricnik-Bay
- Re: greatest/least semantics different between oracle and postgres
- Prev by Date: Re: [pgsql] Simple backup utility like mysqldump?
- Next by Date: Re: varchar(n) VS text
- Previous by thread: Interval overflow?
- Next by thread: Re: greatest/least semantics different between oracle and postgres
- Indexes: