Re: min/max (was: The Contrib Roundup)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
Cc: josh(at)agliodbs(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: min/max (was: The Contrib Roundup)
Date: 2005-06-12 21:30:45
Message-ID: 2501.1118611845@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Jim C. Nasby" <decibel(at)decibel(dot)org> writes:
> What about just adding max(x,y) and min(x,y) to the system functions?

There's already a patch in the queue to do these using the Oracle
spellings (ie, GREATEST(...), LEAST(...)). ISTM that those are
better choices of name, because (a) they are a de facto standard,
and (b) they don't invite confusion with the max() and min() aggregates,
which do something significantly different.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2005-06-13 00:03:46 Re: The Contrib Roundup (long)
Previous Message Tom Lane 2005-06-12 21:27:52 Re: The Contrib Roundup (long)