'greatest' function?

jws wrote:

Is there any buil-in function to return the lesser of two numbers?

i.e. lesser(100,125) would return 100.

Do I need to roll my own?

Which is it--greatest or least?

No matter, TFM has something to say about it:
http://www.postgresql.org/docs/current/static/functions-math.html#FUNCTIONS-MATH-FUNC-TABLE

brian

brian wrote:

jws wrote:

Is there any buil-in function to return the lesser of two numbers?

i.e. lesser(100,125) would return 100.

Do I need to roll my own?

Which is it--greatest or least?

No matter, TFM has something to say about it:
http://www.postgresql.org/docs/current/static/functions-math.html#FUNCTIONS-MATH-FUNC-TABLE

Uh, what function in that table helps him --- I don't see it.

--
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. +

I don't see greatest or least anywhere on that page... But they ARE
here:

http://www.postgresql.org/docs/8.2/interactive/functions-conditional.htm
l#AEN13140

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of brian
Sent: Wednesday, February 07, 2007 10:07 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] 'greatest' function?

jws wrote:

Is there any buil-in function to return the lesser of two numbers?

i.e. lesser(100,125) would return 100.

Do I need to roll my own?

Which is it--greatest or least?

No matter, TFM has something to say about it:
http://www.postgresql.org/docs/current/static/functions-math.html#FUNCTI
ONS-MATH-FUNC-TABLE

brian

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Uh, what function in that table helps him --- I don't see it.

I found GREATEST() and LEAST(), which in combination with COALESCE()
returns exactly what I needed. I missed it because I was looking for
numerical functions. Like so many other things in life, in retrospect,
it's completely obvious.

Adam Rich wrote:

I don't see greatest or least anywhere on that page... But they ARE
here:

http://www.postgresql.org/docs/8.2/interactive/functions-conditional.htm
l#AEN13140

Yes--my bad. Wrong page.