As far as I can tell, Postgres has no equivalent to greatest and least
functions in Oracle.  Yes, you can do the same thing with a case statement,
but at the expense of writing MUCH longer SQL statements.

Is this something that is on or can be added to the 'to do' list?

I could write a series of user-defined functions to do specific 
comparisons (such as comparing several dates and returning the greatest 
one) but there doesn't appear to be a way to write a user function with a 
variable number of parameters, either, so I guess I'd have to define a
series of them with 2,3,4,... parameters.
--
Mike Nolan

Responses

• Re: Greatest/Least functions? at 2004-08-22 17:05:30 from Karsten Hilbert
• Re: Greatest/Least functions? at 2004-08-22 17:32:32 from Joe Conway

pgsql-general by date

Next:	From: Marc G. Fournier	Date: 2004-08-22 16:48:32
	Subject: Re: Unsupported 3rd-party solutions (Was: Few questions
Previous:	From: Mike Nolan	Date: 2004-08-22 16:25:55
	Subject: Re: Unsupported 3rd-party solutions (Was: Few questions on postgresql (dblink, 2pc, clustering)) (fwd)