Re: proposal: variadic argument support for least, greatest function

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: proposal: variadic argument support for least, greatest function
Date: 2018-11-10 18:52:33
Message-ID: CAFj8pRA7E8a+uqLZvy=B+672PiTAWr7_7Tv1yo2y5NaSKJJqtQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

so 10. 11. 2018 v 19:12 odesílatel Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com>
napsal:

> On 08/11/2018 15:59, Pavel Stehule wrote:
> > Hi
> >
> > We can pass variadic arguments as a array to any variadic function. But
> > some our old variadic functions doesn't supports this feature.
> >
> > We cannot to write
> >
> > SELECT least(VARIADIC ARRAY[1,2,3]);
> >
> > Attached patch add this possibility to least, greatest functions.
>
> Is there any particular reason you didn't just make least and greatest
> actual functions?
>

These functions has are able to use most common type and enforce casting.
Generic variadic function cannot do it.

Regards

Pavel

--
> Vik Fearing +33 6 46 75 15 36
> http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dmitry Dolgov 2018-11-10 19:18:33 Re: [HACKERS] Fix performance degradation of contended LWLock on NUMA
Previous Message Andrew Gierth 2018-11-10 18:41:58 Re: proposal: variadic argument support for least, greatest function