"Oracle's ROWNUM"

From: Svenne Krap <usenet(at)krap(dot)dk>
To: pgsql-general(at)postgresql(dot)org
Subject: "Oracle's ROWNUM"
Date: 2001-07-28 21:03:07
Message-ID: l0a6mtgipshbb2ench8dggbimkvcnjgc8o@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)krap(dot)dk - svenne(at)krap(dot)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ryan Mahoney 2001-07-28 21:54:15 Re: "Oracle's ROWNUM"
Previous Message Eric Ridge 2001-07-28 18:10:35 RE: Visual Basic and PostgreSQL ODBC