Re: Largest & Smallest Functions

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Largest & Smallest Functions
Дата
Msg-id CAFj8pRBxXEqse2b6AUbWq2DR8g2DkDCF0g=tH2NYJFcEHru4_A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Largest & Smallest Functions  (Ken Tanzer <ken.tanzer@gmail.com>)
Список pgsql-general
Дерево обсуждения


čt 8. 11. 2018 v 7:02 odesílatel Ken Tanzer <ken.tanzer@gmail.com> napsal:


On Wed, Nov 7, 2018 at 9:48 PM Pavel Stehule <pavel.stehule@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.

These functions are differently implemented - and they are older than support of variadic functions.But implementation of passing a array should be easy.

Pavel


Thanks!

Ken


--
AGENCY Software  
A Free Software data system
By and for non-profits
(253) 245-3801

learn more about AGENCY or
follow the discussion.

В списке pgsql-general по дате отправления: