Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 084C1632A30 for ; Fri, 9 Apr 2010 00:41:37 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 23237-04 for ; Fri, 9 Apr 2010 03:41:26 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f216.google.com (mail-bw0-f216.google.com [209.85.218.216]) by mail.postgresql.org (Postfix) with ESMTP id 62699632333 for ; Fri, 9 Apr 2010 00:41:26 -0300 (ADT) Received: by bwz8 with SMTP id 8so746827bwz.3 for ; Thu, 08 Apr 2010 20:41:25 -0700 (PDT) MIME-Version: 1.0 Received: by 10.204.69.146 with HTTP; Thu, 8 Apr 2010 20:41:10 -0700 (PDT) In-Reply-To: <4BBE33B0.1050408@gmx.net> References: <4BBE33B0.1050408@gmx.net> From: Jaime Casanova Date: Thu, 8 Apr 2010 22:41:10 -0500 Received: by 10.204.9.23 with SMTP id j23mr1174609bkj.132.1270784485229; Thu, 08 Apr 2010 20:41:25 -0700 (PDT) Message-ID: Subject: Re: Howto get a group_number like row_number for groups To: Andreas Cc: pgsql-sql@postgresql.org Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201004/33 X-Sequence-Number: 33960 On Thu, Apr 8, 2010 at 2:51 PM, Andreas wrote: > or rank() =C2=A0over =C2=A0(order by =C2=A0object, =C2=A0 ts) =C2=A0% =C2= =A02 use dense_rank() instead --=20 Atentamente, Jaime Casanova Soporte y capacitaci=C3=B3n de PostgreSQL Asesor=C3=ADa y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157