On Saturday 30 June 2007 14:13, paul rivers wrote: > > -----Original Message----- > > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- > > owner@xxxxxxxxxxxxxx] On Behalf Of Pavel Stehule > > Sent: Saturday, June 30, 2007 10:37 AM > > To: Bruno Wolff III; Pavel Stehule; pgsql-general@xxxxxxxxxxxxxx > > Subject: Re: [GENERAL] greatest/least semantics different between oracle > > and postgres > > > > > Maybe that reference was for an earlier version of Oracle and the > > > > definition > > > > > changed at some point? I only have access to version 9 and greatest and > > > lest are strict there. > > > > I am installing OracleXE and I'll test it. > > > > Pavel > > At risk of putting my foot in my mouth again, greatest() returns null if > one or more expressions are null for Oracle enterprise 9.2.0.7 and > 10.2.0.3. > <snip examples> Confirmed on Oracle 8.1.7.4.0 as well, so if it changed it was a ways back. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
