公有云、专有云、一体机
PolarDB高度兼容Oracle版本20200228
PolarDB如何兼容Oracle的sys_guid函数
在20200130内核版本,PolarDB提供了一个插件支持sys_guid函数:
create extension "uuid-ossp";
create extension "sys_guid";
select sys_guid();
sys_guid
------------------------------------
\x06140b2fe38d4575a0780c74ca4a54d9
create extension "uuid-ossp";
create or replace function sys_guid() returns uuid as $$
select uuid_generate_v4();
$$ language sql strict;
select sys_guid();
sys_guid
--------------------------------------
92aebb17-1a42-43e9-8a29-f688db0331eb
create or replace function sys_guid() returns text as $$
select replace(uuid_generate_v4()::text,'-','');
$$ language sql strict;