Fungsi/Function untuk uuid versi 4 di postgresql
create function uuid_generate_v4()
returns varchar
language plpgsql
as
$$
declare
uuid varchar;
begin
select uuid_in(overlay(overlay(md5(random()::text || ':' || random()::text) placing '4' from 13) placing to_hex(floor(random()*(11-8+1) + 8)::int)::text from 17)::cstring)
into uuid;
return uuid;
end;
$$;
-- cara pakai
select uuid_generate_v4();
Komentar
Posting Komentar