| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | "paul rivers" <rivers(dot)paul(at)gmail(dot)com>, "'Pavel Stehule'" <pavel(dot)stehule(at)gmail(dot)com>, "'Bruno Wolff III'" <bruno(at)wolff(dot)to> |
| Subject: | Re: greatest/least semantics different between oracle and postgres |
| Date: | 2007-07-01 17:10:05 |
| Message-ID: | 200707011310.05728.xzilla@users.sourceforge.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Saturday 30 June 2007 14:13, paul rivers wrote:
> > -----Original Message-----
> > From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> > owner(at)postgresql(dot)org] On Behalf Of Pavel Stehule
> > Sent: Saturday, June 30, 2007 10:37 AM
> > To: Bruno Wolff III; Pavel Stehule; pgsql-general(at)postgresql(dot)org
> > 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2007-07-01 17:19:52 | Re: Standby servers and incrementally updated backups |
| Previous Message | Ben | 2007-07-01 15:27:01 | Re: [ASK] create data ware house in postgre |