Postgres Pro
Downloads
Home   >   mailing lists

Re: (How to) Make SQLData of UUID? - Mailing list pgsql-jdbc

From Alexander Myodov
Subject Re: (How to) Make SQLData of UUID?
Date
Msg-id CAHF95JwePa0h38KsWRm-jTbQAdKcbjRrGAQuzHK1JSG8u9guOQ@mail.gmail.com
Whole thread Raw
In response to Re: (How to) Make SQLData of UUID?  (Basil Bourque <basil.bourque@gmail.com>)
Responses Re: (How to) Make SQLData of UUID?  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-jdbc
Tree view
Not so much, sorry :(

The problem is not in making a PL/PgSQL function returning an UUID. Or even returning a custom type containing an UUID (like MYFUNC_RETURN_TYPE in my case). The problem is on Java level, when I need to make a Java handler/mapping of PostgreSQL custom type (which contains an UUID internally).

For now I, instead of out.writeObject, made it through out.writeString(key.toString()), but I am very unsure if this is how it should be done. And if the opposite way, key = (UUID) in.readObject() is also safe.


пн, 22 июл. 2019 г. в 02:09, Basil Bourque <basil.bourque@gmail.com>:
Any hints please?


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


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


--
Alex Myodov

pgsql-jdbc by date:

Previous
From: Basil Bourque
Date:
Subject: Re: (How to) Make SQLData of UUID?
Next
From: Thomas Kellerer
Date:
Subject: Re: (How to) Make SQLData of UUID?