čt 8. 11. 2018 v 7:02 odesílatel Ken Tanzer <ken.tan...@gmail.com> napsal:
> > > On Wed, Nov 7, 2018 at 9:48 PM Pavel Stehule <pavel.steh...@gmail.com> > wrote: > >> >> You can pass variadic arguments as a array >> >> postgres=# \sf smallest >> CREATE OR REPLACE FUNCTION public.smallest(VARIADIC anyarray) >> RETURNS anyelement >> LANGUAGE sql >> IMMUTABLE >> AS $function$ >> SELECT min($1[i]) FROM generate_subscripts($1, 1) g(i); >> $function$ >> >> postgres=# select smallest(VARIADIC ARRAY[1,2,3]); >> ┌──────────┐ >> │ smallest │ >> ╞══════════╡ >> │ 1 │ >> └──────────┘ >> (1 row) >> >> > That's very helpful and good to know. It's too bad that doesn't work with > LEAST/GREATEST, which would eliminate the need for extra functions. > I sent a patch to pgsql-hackares that allows VARIADIC argument for LEAST/GREATEST Regards Pavel > > Thanks! > > Ken > > > -- > AGENCY Software > A Free Software data system > By and for non-profits > *http://agency-software.org/ <http://agency-software.org/>* > *https://demo.agency-software.org/client > <https://demo.agency-software.org/client>* > ken.tan...@agency-software.org > (253) 245-3801 > > Subscribe to the mailing list > <agency-general-requ...@lists.sourceforge.net?body=subscribe> to > learn more about AGENCY or > follow the discussion. >
