Enhancement request: enable FIRST/LAST_value() also as a regular aggregate (not only as windowing function)

2018-07-24 Thread matshyeq
Hi All, I'd like to throw here an enhancement proposal to discuss/consider. The FIRST/LAST_value() functions offer powerful lookup capabilities, eg. here 1) https://dbfiddle.uk/?rdbms=postgres_9.6&fiddle=0

Re: Enhancement request: enable FIRST/LAST_value() also as a regular aggregate (not only as windowing function)

2018-07-24 Thread matshyeq
ions could be made available as some new Ordered-Set Aggregate Functions <https://www.postgresql.org/docs/devel/static/functions-aggregate.html#FUNCTIONS-ORDEREDSET-TABLE> too… On Tue, 24 Jul 2018 at 23:16, Tom Lane wrote: > matshyeq writes: > > I'd like to throw here an enhanc

Re: Enhancement request: enable FIRST/LAST_value() also as a regular aggregate (not only as windowing function)

2018-07-26 Thread matshyeq
Regards ~Maciek On Thu, 26 Jul 2018 at 16:22, Robert Haas wrote: > On Tue, Jul 24, 2018 at 4:16 PM, matshyeq wrote: > >> I'd like to throw here an enhancement proposal to discuss/consider. >> The FIRST/LAST_value() >> <https://www.postgresql.org/docs/devel