how to get row number in select query - Mailing list pgsql-sql

From Emi Lu
Subject how to get row number in select query
Date
Msg-id 4D4047C1.5030208@encs.concordia.ca
Whole thread Raw
List pgsql-sql
Good morning,

For postgresql 8.3, what is the system method/key word to get row number 
please?

E.g.,

==================
lname1 gname1
lname2 gname2
lname3 gname3
......

I'd like to get

1  lname1   gname1
2  lname2   gname2
3  lname3   gname3

... ...

Something like
select row_number?, lname, gname from Table1;

Thanks a lot!


--
Lu Ying


pgsql-sql by date:

Previous
From: msi77
Date:
Subject: Re: Queyring for columns which are exist in table.
Next
From: "Oliveiros d'Azevedo Cristina"
Date:
Subject: Re: how to get row number in select query