row numbering - Mailing list pgsql-general

From Marcin Inkielman
Subject row numbering
Date
Msg-id Pine.LNX.4.21.0005101440500.21509-100000@mi.marnnet
Whole thread Raw
In response to Documentation about Postgres architecture  ("Patrick FICHE" <pfiche@prologue-software.fr>)
Responses Re: row numbering
List 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


pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Re: textpos() function
Next
From: Ron Peterson
Date:
Subject: Re: libpq.so.2.1 missing