X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5E778D1F0C3 for ; Tue, 4 May 2004 14:37:55 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 72792-03 for ; Tue, 4 May 2004 14:37:33 -0300 (ADT) Received: from p15124592.pureserver.info (p15124592.pureserver.info [217.160.181.164]) by svr1.postgresql.org (Postfix) with ESMTP id 3ED6DD1E402 for ; Tue, 4 May 2004 14:37:32 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by p15124592.pureserver.info (Postfix) with ESMTP id 6436C1795A for ; Tue, 4 May 2004 19:37:31 +0200 (CEST) Received: from sarge (p508A9FF5.dip0.t-ipconnect.de [80.138.159.245]) by p15124592.pureserver.info (Postfix) with ESMTP id B17F717959 for ; Tue, 4 May 2004 19:37:30 +0200 (CEST) Received: from mk-os.de (unknown [192.168.0.210]) by sarge (Postfix) with ESMTP id 5D2553EC05 for ; Tue, 4 May 2004 19:37:30 +0200 (CEST) Message-ID: <4097D53E.6060400@mk-os.de> Date: Tue, 04 May 2004 19:39:10 +0200 From: Martin Knipper User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de-AT; rv:1.6) Gecko/20040113 X-Accept-Language: de-at, de, en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: Rank References: <003e01c42fa9$5677b240$4f00a8c0@MIDDINKS> <20040504101119.58d355cb.gry@ll.mit.edu> <4097B34B.7070102@mk-os.de> <4097C924.2060307@itsbeen.sent.com> In-Reply-To: <4097C924.2060307@itsbeen.sent.com> X-Enigmail-Version: 0.83.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS at MK-OS X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=RCVD_IN_NJABL, RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200405/43 X-Sequence-Number: 17757 Am 04.05.2004 18:47 schrieb Rob: > Martin Knipper wrote: >>Am 04.05.2004 16:11 schrieb george young: >>>On Sun, 2 May 2004 02:22:37 +0800 >>>"Muhyiddin A.M Hayat" threw this fish to the penguins: >>> >>>>I Have below table >>>> >>>>id | site_name | point >>>>----+-----------+------- >>>>1 | Site A | 40 >>>>2 | Site B | 90 >>>>3 | Site D | 22 >>>>4 | Site X | 98 >>>> >>>>Would like to calc that Rank for each site, and look like >>>> >>>>id | site_name | point | rank >>>>----+-----------+-------+------ >>>>1 | Site A | 40 | 3 >>>>2 | Site B | 90 | 2 >>>>3 | Site D | 22 | 4 >>>>4 | Site X | 98 | 1 >>> >>> [...] >> >>Another possibilty is to use a sequence: >> >>demo=# create temporary sequence ranking; >>demo=# select *,nextval('ranking') as rank from yourTable order by >>site_name asc; >> > > wouldn't it have to be: > > select *, nextval('ranking') as rank > from yourTable > order by point desc; > > for the ranking to work? > Yes, you are right. I guess I was a little confused with the ordering in the example table Muhyiddin provided. Greetings, Martin -- Martin Knipper www : http://www.mk-os.de Mail : knipper@mk-os.de