[SQL] Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle?

[Dennis.Jiang]

Hi:

Oracle has a pseudo-column "ROWNUM" to return the sequence number in which a 
row was returned when selected from a table. The first row ROWNUM is 1, the 
second is 2, and so on.

Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle? If so, we can 
write the following query:

select * 
from (select RowNum, pg_catalog.pg_proc.* 
        from pg_catalog.pg_proc) inline_view
where RowNum between 100 and 200;


Thanks,
Dennis


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly