| From: | Antoine Besnier <besnier_antoine(at)yahoo(dot)fr> |
|---|---|
| To: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: Regarding UUID |
| Date: | 2023-02-08 10:37:19 |
| Message-ID: | 1612831686.2850460.1675852639448@mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
You'd need to convert your string to a valid UUID first.See https://stackoverflow.com/questions/29059530/is-there-any-way-to-generate-the-same-uuid-from-a-string for ideas
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(dot)albe(at)cybertec(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vikas Choudhary | 2023-02-09 01:45:28 | Support cycle & EOVS dates information for PostgreSQL JDBC driver |
| Previous Message | Laurenz Albe | 2023-02-08 10:21:17 | Re: Regarding UUID |