"Oracle's ROWNUM" - Mailing list pgsql-general

From Svenne Krap
Subject "Oracle's ROWNUM"
Date
Msg-id l0a6mtgipshbb2ench8dggbimkvcnjgc8o@4ax.com
Whole thread Raw
Responses Re: "Oracle's ROWNUM"  (Ryan Mahoney <ryan@paymentalliance.net>)
List pgsql-general
Hi,

is there any way to get the number of the tuple in the result set...

in Oracle you can write

select rownum, * from mytable;

and then get (handmade example) :

rownum | id | name
-----------------------------
1     | 27| John Dow
2    | 09 | Jane Dow
3    | 11 | Bugs Bunny


Tia

Svenne Krap
--
Mail usenet@krap.dk - svenne@krap.dk - PGP key id : 0xDF484022
ICQ: 5434480 - http://www.krap.dk - http://www.krap.net
PGP Key http://keys.pgp.dk:11371/pks/lookup?op=get&search=0xDF484022

pgsql-general by date:

Previous
From: "Eric Ridge"
Date:
Subject: RE: Visual Basic and PostgreSQL ODBC
Next
From: Ryan Mahoney
Date:
Subject: Re: "Oracle's ROWNUM"