Re: (How to) Make SQLData of UUID?

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(dot)bourque(at)gmail(dot)com>:

> Any hints please?
>
>
> Does this Answer by Gopinagh.R on Stack Overflow help?
>
> 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
>

--
Alex Myodov