Re: Regarding UUID - Mailing list pgsql-jdbc

From Antoine Besnier
Subject Re: Regarding UUID
Date
Msg-id 1612831686.2850460.1675852639448@mail.yahoo.com
Whole thread Raw
In response to Re: Regarding UUID  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-jdbc
You'd need to convert your string to a valid UUID first.

What do you mean by "customised UUID"? UUID format is standardized by definition.

But that looks like a X-Y problem. If you already have an ID, why generate a new one?

Antoine



Le mercredi 8 février 2023 à 11:21:24 UTC+1, Laurenz Albe <laurenz.albe@cybertec.at> a écrit :


On Wed, 2023-02-08 at 15:25 +0530, lekha Tripathi wrote:

> I am having a table with a column type UUID and to insert this column value i
> am having value like "1344443456" in text datatype and i want to insert this value as UUID .
> While trying to insert this value getting error for UUID ,
> So is any way to convert my given value into customised UUID?
> Let me know if any way to do so.


That does not look like a valid UUID at all.  I have no idea how that could be
converted to an UUID, same as I don't know how "hello" should be converted to
a timestamp.  Perhaps you have some more information?

Yours,
Laurenz Albe



pgsql-jdbc by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Regarding UUID
Next
From: Vikas Choudhary
Date:
Subject: Support cycle & EOVS dates information for PostgreSQL JDBC driver