Jose' Soares wrote:
> Anand Surelia wrote:
> >
> > Hi,
> > I want to display serial numbers of rows selected by a query. I can do
> > this in Oracle by selecting a special attribute called 'rownum' (or
> > 'rowno'). Can I do this in Postgres too? If not then is there any
> > alternative in Postgres?
> >
> SELECT oid, * FROM tablename;
>
> Jose'
>
No I dont't want the oids but the serial number of a row in the present
output of the query. For e.g in Oracle we have:
select rownum,name from tablename;
will give me,
rownum | name
1 | Anand
2 | Jose' Soares
3 | Someone
Thanks,
Anand.