>>>>> "Vik" == Vik Fearing <vik.fearing@2ndquadrant.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)