更新时间:2026-10-21 GMT+08:00
分享

ROWID类型函数

  • rowid_tableoid(rowid)

    描述:获取rowid的table_oid值。

    参数: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的row_no值。

    参数: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的node_slice值。

    参数: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的bucket_id值。

    参数: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

相关文档