Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 9B3A19FB444 for ; Tue, 15 May 2007 09:11:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 10572-06 for ; Tue, 15 May 2007 09:11:46 -0300 (ADT) X-Greylist: delayed 00:31:04.395178 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 7C7429FB4CF for ; Tue, 15 May 2007 09:11:46 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from xsmtp07.mail2web.com (xsmtp07.mail2web.com [168.144.250.170]) by svr4.postgresql.org (Postfix) with ESMTP id 31ECF5AF02A for ; Tue, 15 May 2007 11:40:41 +0000 (GMT) Received: from [168.144.108.15] (helo=M2W015.mail2web.com) by xsmtp07.mail2web.com with smtp (Exim 4.63) (envelope-from ) id 1HnvOD-0003SR-8I for pgsql-sql@postgresql.org; Tue, 15 May 2007 07:40:40 -0400 Message-ID: <380-220075215114025163@M2W015.mail2web.com> X-Priority: 3 Reply-To: ashok@kalculate.com X-Originating-IP: 59.176.106.240 X-URL: http://mail2web.com/ From: "ashok@kalculate.com" To: pgsql-sql@postgresql.org Subject: Serial number of a record Date: Tue, 15 May 2007 07:40:25 -0400 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL=0.004, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200705/130 X-Sequence-Number: 28410 Hi List, I have one table something like this Name Age =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D tom 20 ram 25 shyam 30 balram 15 hari 10 Now i want serial number of a record=2E Suppose if i will fire a query "select Name from tablename where age=3D30"= =2E it will give output "shyam" but i also want record no=2E other then oid, i= n this case it is 3=2E is it possible=3F if yes then how=3F plz=2E help me=2E Thanks Ashok -------------------------------------------------------------------- mail2web=2Ecom - Microsoft=AE Exchange solutions from a leading provider -= http://link=2Email2web=2Ecom/Business/Exchange