Is there an open source SQL database that has the concept of an Oracle "rowid" pseudo-column?

Question

I know that MySQL and PostgreSQL [1] do not have such a concept, so I am interested to know if there is an open source SQL database that has a concept.

[1] It was later pointed out that PostgreSQL has a pseudo-column rowid.

Answer 1

PostgreSQL has this concept.

See here for a short list of pseudo-commands in PostgreSQLwhich ctidyou are interested in:

ctid (tuple identifier)

, . ​​ctid: .

Oracle rowid.

MySQL, .

MyISAM, rowid - , , , .

InnoDB index organized , , - , InnoDB PRIMARY KEY .

Oracle index organized, rowid , logical ROWID UROWID

rowid index organized Oracle, , (- *BAEBwPICwQL+). PRIMARY KEY.

: - PRIMARY KEY, MySQL PRIMARY KEY, .

- a PRIMARY KEY InnoDB: , .

Answer 2

, .

Answer 3

SQLite "ROWID", , ROWID, _ROWID OID. , .