Re: greatest/least semantics different between oracle and postgres - Mailing list pgsql-general

From Bruce Momjian
Subject Re: greatest/least semantics different between oracle and postgres
Date
Msg-id 200706301613.l5UGDmx25259@momjian.us
Whole thread Raw
In response to Re: greatest/least semantics different between oracle and postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Tom Lane wrote:
> >> Anyway, there's no doubt that we can point to the behavior of MAX/MIN
> >> as defense for what we made GREATEST/LEAST do, so I'm inclined to leave
> >> their behavior alone, at least until such time as they're actually
> >> standardized.  But a note in the manual pointing out the difference from
> >> Oracle seems in order.
>
> > Agreed that we are good by following min/max.  Not sure about a mention
> > in the docs that we are different from Oracle helps.  Do we mention
> > other differences?  I see us doing that only for PL/Psql.
>
> We tend not to mention Oracle by name, but there are various places
> saying that we do X while "some other databases" do Y.  In view of the
> mysql behavior I think I'd use that same wording here.

OK, I like the generic approach.

--
  Bruce Momjian  <bruce@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: greatest/least semantics different between oracle and postgres
Next
From: "John D. Burger"
Date:
Subject: Re: greatest/least semantics different between oracle and postgres