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. 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.