Re: LEAST and GREATEST functions? - Mailing list pgsql-sql

From Tom Lane
Subject Re: LEAST and GREATEST functions?
Date
Msg-id 24828.1057124242@sss.pgh.pa.us
Whole thread Raw
In response to Re: LEAST and GREATEST functions?  (Ang Chin Han <angch@bytecraft.com.my>)
Responses Re: LEAST and GREATEST functions?  (Ang Chin Han <angch@bytecraft.com.my>)
List pgsql-sql
Ang Chin Han <angch@bytecraft.com.my> writes:
> If LEAST and GREATEST can accept any number of parameters, wouldn't it 
> make sense to code it like the way COALESCE works, rather than defining 
> a function for it? This way we don't need define all the various 
> functions with different types.

But COALESCE is a special feature hard-wired into the parser.  There's
no free lunch --- you pay for your extensibility somewhere.
        regards, tom lane


pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Break referential integrity.
Next
From: "Atul Pedgaonkar"
Date:
Subject: About Postgresql Service on SUN OS