oracle rownum equivalent? - Mailing list pgsql-sql

is there an equivalent to rownum in oracle?

also, where can one find reference to "hidden columns"
such as OID or, as in oracle, rownum?

thanks,

  mikeo