Re: (How to) Make SQLData of UUID?

Поиск
Список
Период
Сортировка
От Alexander Myodov
Тема Re: (How to) Make SQLData of UUID?
Дата
Msg-id CAHF95JwePa0h38KsWRm-jTbQAdKcbjRrGAQuzHK1JSG8u9guOQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: (How to) Make SQLData of UUID?  (Basil Bourque <basil.bourque@gmail.com>)
Ответы Re: (How to) Make SQLData of UUID?
Список pgsql-jdbc
Дерево обсуждения
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 по дате отправления: