Home > mailing lists

first_value/last_value - Mailing list pgsql-general

From	Tom Smith
Subject	first_value/last_value
Date	May 19, 2016 03:46:41
Msg-id	CAKwSVFGPB7OigYFqw+SJ4QfMFvUtH5+pqvm4TrM3jKgTR_2r-g@mail.gmail.com Whole thread Raw
Responses	Re: first_value/last_value Re: first_value/last_value
List	pgsql-general

Hello:

Is there a plan for 9.7 to enable using the two aggregate function

as non-window function? i.e. enabling getting the first/last row

in single sql without using window features.

There is actually a C-extension for first()/last().

I am wondering if 9.7 would make them built-in function like max/min

Thanks

From: "Rene ."
Date: 19 May 2016, 01:03:47
Subject: Re: Londiste 3 pgq events_1_1 table huge

From: Adam Brusselback
Date: 19 May 2016, 04:08:20
Subject: Re: first_value/last_value