first_value/last_value

From: Tom Smith <tomsmith1989sk(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: first_value/last_value
Date: 2016-05-19 00:46:35
Message-ID: CAKwSVFGPB7OigYFqw+SJ4QfMFvUtH5+pqvm4TrM3jKgTR_2r-g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Brusselback 2016-05-19 01:08:11 Re: first_value/last_value
Previous Message Rene . 2016-05-18 22:03:36 Re: Londiste 3 pgq events_1_1 table huge