Re: proposal: variadic argument support for least, greatest function

>>>>> "Vik" == Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com> writes:

>> Attached patch add this possibility to least, greatest functions.

Vik> Is there any particular reason you didn't just make least and
Vik> greatest actual functions?

least() and greatest() have some type unification logic that I don't
think works for actual functions.

create function s(variadic anyarray) returns anyelement
language sql immutable
as $$ select min(v) from unnest($1) u(v); $$;

select s(1,2,3); -- works
select s(1,2,3.0); -- ERROR: function s(integer, integer, numeric) does not exist
select least(1,2,3.0); -- works

--
Andrew (irc:RhodiumToad)