更新时间:2026-10-21 GMT+08:00
ROWID类型函数
- rowid_tableoid(rowid)
参数:rowid
返回值类型:oid
示例:
gaussdb=# CREATE DATABASE ora_test DBCOMPATIBILITY='ORA'; CREATE DATABASE gaussdb=# \c ora_test Non-SSL connection (SSL connection is recommended when requiring high-security) You are now connected to database "ora" as user "$user". ora_test=# SELECT rowid_tableoid('AAAAAAAAAP//BBBBBAAAAAAAAAAAC'); rowid_tableoid ---------------- 1090785344 (1 row) ora_test=# \c postgres Non-SSL connection (SSL connection is recommended when requiring high-security) You are now connected to database "postgres" as user "$user". gaussdb=# DROP DATABASE ora_test; DROP DATABASE
- rowid_sequence(rowid)
参数:rowid
返回值类型:int8
示例:
gaussdb=# CREATE DATABASE ora_test DBCOMPATIBILITY='ORA'; CREATE DATABASE gaussdb=# \c ora_test Non-SSL connection (SSL connection is recommended when requiring high-security) You are now connected to database "ora" as user "$user". ora_test=# SELECT rowid_sequence('AAAAAAAAAP//BBBBBAAAAAAAAAAAC'); rowid_sequence ---------------- 2 (1 row) ora_test=# \c postgres Non-SSL connection (SSL connection is recommended when requiring high-security) You are now connected to database "postgres" as user "$user". gaussdb=# DROP DATABASE ora_test; DROP DATABASE - rowid_nodeid(rowid)
参数:rowid
返回值类型:int2
示例:
gaussdb=# CREATE DATABASE ora_test DBCOMPATIBILITY='ORA'; CREATE DATABASE gaussdb=# \c ora_test Non-SSL connection (SSL connection is recommended when requiring high-security) You are now connected to database "ora" as user "$user". ora_test=# SELECT rowid_nodeid('AAAAAAAAAP//BBBBBAAAAAAAAAAAC'); rowid_nodeid -------------- 0 (1 row) ora_test=# \c postgres Non-SSL connection (SSL connection is recommended when requiring high-security) You are now connected to database "postgres" as user "$user". gaussdb=# DROP DATABASE ora_test; DROP DATABASE - rowid_hashbucketid(rowid)
参数:rowid
返回值类型:int2
示例:
gaussdb=# CREATE DATABASE ora_test DBCOMPATIBILITY='ORA'; CREATE DATABASE gaussdb=# \c ora_test Non-SSL connection (SSL connection is recommended when requiring high-security) You are now connected to database "ora" as user "$user". ora_test=# SELECT rowid_hashbucketid('AAAAAAAAAP//BBBBBAAAAAAAAAAAC'); rowid_hashbucketid -------------------- -1 (1 row) ora_test=# \c postgres Non-SSL connection (SSL connection is recommended when requiring high-security) You are now connected to database "postgres" as user "$user". gaussdb=# DROP DATABASE ora_test; DROP DATABASE
父主题: 函数和操作符