how to get row number in select query

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: how to get row number in select query
Date: 2011-01-26 16:11:45
Message-ID: 4D4047C1.5030208@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Oliveiros d'Azevedo Cristina 2011-01-26 16:40:45 Re: how to get row number in select query
Previous Message msi77 2011-01-26 07:17:46 Re: Queyring for columns which are exist in table.