Row Nums

From: Anand Surelia <anand(at)bytekinc(dot)com>
To: "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgreSQL(dot)org>
Subject: Row Nums
Date: 1998-10-07 17:58:34
Message-ID: 361BABC9.924BE56A@bytekinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I want to display serial numbers of rows selected by a query. I can do
this in Oracle by selecting a special attribute called 'rownum' (or
'rowno'). Can I do this in Postgres too? If not then is there any
alternative in Postgres?

Thanks,
Anand.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tom 1998-10-07 18:45:16 Re: [GENERAL] Row Nums
Previous Message Bruce Momjian 1998-10-07 17:56:18 Re: [HACKERS] RE: [GENERAL] Long update query ? (also Re: [GENERAL] CNF vs. DNF)