Home > mailing lists

Re: Howto get a group_number like row_number for groups - Mailing list pgsql-sql

From	Jaime Casanova
Subject	Re: Howto get a group_number like row_number for groups
Date	April 9, 2010 03:41:37
Msg-id	m2n3073cc9b1004082041v38841af0w960472964dd0e388@mail.gmail.com Whole thread Raw
In response to	Howto get a group_number like row_number for groups (Andreas <maps.on@gmx.net>)
List	pgsql-sql

Tree view

On Thu, Apr 8, 2010 at 2:51 PM, Andreas <maps.on@gmx.net> wrote:
> or rank()  over  (order by  object,   ts)  %  2

use dense_rank() instead

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

pgsql-sql by date:

From: Andreas
Date: 08 April 2010, 19:51:25
Subject: Howto get a group_number like row_number for groups

From: Svenne Krap
Date: 09 April 2010, 07:24:45
Subject: Cascading sum in tree with CTE?

Re: Howto get a group_number like row_number for groups - Mailing list pgsql-sql

Previous

Next