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/stat

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)

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

2018-07-24 Thread matshyeq
ocs/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 enhancement proposal to discuss/consider. > > The FIRST/LAST_value() > > functions offer powerful lookup