X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CEB8BDA743 for ; Fri, 28 Oct 2005 08:18:27 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 49169-04 for ; Fri, 28 Oct 2005 11:18:24 +0000 (GMT) Received: from mail.fgscapital.com (fw.fgscapital.com [82.110.72.114]) by svr1.postgresql.org (Postfix) with ESMTP id C8C7DDA53F for ; Fri, 28 Oct 2005 08:18:24 -0300 (ADT) Received: (qmail 18416 invoked by uid 1003); 28 Oct 2005 11:18:26 -0000 Received: from adegregorio@fgscapital.com by mail.fgscapital.com by uid 89 with qmail-scanner-1.21 (clamdscan: 0.70-rc. spamassassin: 2.63. Clear:RC:1(192.168.0.114):. Processed in 0.022126 secs); 28 Oct 2005 11:18:26 -0000 Received: from unknown (HELO alessandra) (adegregorio@fgscapital.com@192.168.0.114) by 192.168.110.115 with SMTP; 28 Oct 2005 11:18:26 -0000 From: "alessandra de gregorio" To: Subject: serial in output Date: Fri, 28 Oct 2005 12:18:21 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcXbsU1uAxnbfd7+Qd+gaUJ81OtIqw== X-Qmail-Scanner-Message-ID: <113049830666118410@mail.fgscapital.com> Message-Id: <20051028111824.C8C7DDA53F@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.927 required=5 tests=[MSGID_FROM_MTA_ID=0.927] X-Spam-Score: 0.927 X-Spam-Level: X-Archive-Number: 200511/49 X-Sequence-Number: 23301 Hi, What function should I use to get a serial number, together with my results, from a query? Ex. Of output I want: 1 ooo pp ij 2 hou joo iu 3 bhi ft yh Basically, I would like to have one column with integers, from 1 onwards, no matter how many tables I join in, or the data that I get back. Thanks