Re: [GENERAL] Row Nums

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.