Re: Howto get a group_number like row_number for groups

From: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
To: Andreas <maps(dot)on(at)gmx(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Howto get a group_number like row_number for groups
Date: 2010-04-09 03:41:10
Message-ID: m2n3073cc9b1004082041v38841af0w960472964dd0e388@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, Apr 8, 2010 at 2:51 PM, Andreas <maps(dot)on(at)gmx(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Svenne Krap 2010-04-09 07:17:49 Cascading sum in tree with CTE?
Previous Message Andreas 2010-04-08 19:51:12 Howto get a group_number like row_number for groups