Re: Largest & Smallest Functions

On Thu, Nov 8, 2018 at 7:01 AM Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
wrote:

> 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
>
>
That's great! Thanks for doing that!

Cheers,
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(dot)tanzer(at)agency-software(dot)org
(253) 245-3801

Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.