Обсуждение: SQL window functions

Поиск
Список
Период
Сортировка

SQL window functions

От
Hannes Dorbath
Дата:
What is the state of SQL window functions in PostgreSQL? rank(),
dense_rank() over() etc?

Is there work done or planed to add those to PostgreSQL? Is there
experimental code?

--
Best regards,
Hannes Dorbath

Re: SQL window functions

От
"Roberts, Jon"
Дата:
Greenplum has it.  Maybe they are planning on adding it to Bizgres or
PostgreSQL.


Jon

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Hannes Dorbath
> Sent: Sunday, May 04, 2008 8:02 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] SQL window functions
>
> What is the state of SQL window functions in PostgreSQL? rank(),
> dense_rank() over() etc?
>
> Is there work done or planed to add those to PostgreSQL? Is there
> experimental code?
>
> --
> Best regards,
> Hannes Dorbath
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

Re: SQL window functions

От
Hannes Dorbath
Дата:
Roberts, Jon wrote:
> Greenplum has it.  Maybe they are planning on adding it to Bizgres or
> PostgreSQL.

Sadly Bizgres seems kinda stalled. Latest news is from 2006.06.09. I
doubt GP is still maintaining it at all..


--
Best regards,
Hannes Dorbath