Re: (How to) Make SQLData of UUID?

From: Basil Bourque <basil(dot)bourque(at)gmail(dot)com>
To: pgsql-jdbc(at)lists(dot)postgresql(dot)org
Subject: Re: (How to) Make SQLData of UUID?
Date: 2019-07-21 23:08:58
Message-ID: C9651950-4F9D-47FF-80CA-631ECAC02A65@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

> Any hints please?
>

Does this Answer by Gopinagh.R on Stack Overflow help?

https://stackoverflow.com/a/14197445/642706 <https://stackoverflow.com/a/14197445/642706>

CREATE OR REPLACE FUNCTION generatesurrogat() RETURNS uuid AS
$BODY$DECLARE
uid UUID;
BEGIN
uid:=(select uuid_generate_v1());
RAISE NOTICE 'My UUID is %',uid;
return uid;
END$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;

—BB

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Alexander Myodov 2019-07-21 23:43:20 Re: (How to) Make SQLData of UUID?
Previous Message Rob Sargent 2019-07-21 22:44:15 Re: (How to) Make SQLData of UUID?