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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of brian Sent: Wednesday, February 07, 2007 10:07 PM To: pgsql-general@xxxxxxxxxxxxxx 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
