row numbering

From: Marcin Inkielman <marn(at)wsisiz(dot)edu(dot)pl>
To: Pgsql-General <pgsql-general(at)postgresql(dot)org>
Subject: row numbering
Date: 2000-05-10 12:47:39
Message-ID: Pine.LNX.4.21.0005101440500.21509-100000@mi.marnnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


HI!

i have a little question:

how may i easyly obtain row numbers in a query:

for example how may i obtain:

select <<row_number>>, * from a_table_or_view;

i did some experiences with sequences but without satisfying results;

thx for any hint.

Marcin Inkielman

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Peterson 2000-05-10 13:11:02 Re: libpq.so.2.1 missing
Previous Message Mike Mascari 2000-05-10 11:01:30 Re: textpos() function