public inbox for [email protected]  

help / color / mirror / Atom feed

Regarding UUID
3+ messages / 3 participants
[nested] [flat]

* Regarding UUID
@ 2023-02-08 09:55  lekha Tripathi <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: lekha Tripathi @ 2023-02-08 09:55 UTC (permalink / raw)
  To: pgsql-jdbc

Hi,
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.

Regards
Lekha


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Regarding UUID
@ 2023-02-08 10:21  Laurenz Albe <[email protected]>
  parent: lekha Tripathi <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Laurenz Albe @ 2023-02-08 10:21 UTC (permalink / raw)
  To: lekha Tripathi <[email protected]>; pgsql-jdbc

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





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Regarding UUID
@ 2023-02-08 10:37  Antoine Besnier <[email protected]>
  parent: Laurenz Albe <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: Antoine Besnier @ 2023-02-08 10:37 UTC (permalink / raw)
  To: 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-strin... 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 <[email protected]> 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


  

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2023-02-08 10:37 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-02-08 09:55 Regarding UUID lekha Tripathi <[email protected]>
2023-02-08 10:21 ` Laurenz Albe <[email protected]>
2023-02-08 10:37   ` Antoine Besnier <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox