By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,649 Members | 696 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,649 IT Pros & Developers. It's quick & easy.

Support for ROWNUM and ROWID

P: 10
hi all

Is postgreSQL supports ROWNUM and ROWID ?


-thanks-
Chitranjan Singh
May 17 '07 #1
Share this Question
Share on Google+
3 Replies


Expert 100+
P: 534
Postgresql does not have an equivalent of Oracle's ROWNUM.
In many cases you can achieve the same result by using LIMIT and OFFSET in your query.

Same with ROWID; it does not exist in Postgresql, but you can use CTID as a reference to a row. CTID is a system column containing the file block number and position in the block for the row.

Sometimes people use OID, but in the latest releases this system column is optional, and it is not created unless you explicitly request it in your "CREATE TABLE" statement.
May 17 '07 #2

dmjpro
100+
P: 2,476
Is CTID unique???

Debasis Jana.
Jul 3 '08 #3

P: 1
@dmjpro
It is. It is not guaranteed to be incremental, but it is always unique.
Mar 27 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.