Re: GUIDs

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: David Wheeler <david(at)kineticode(dot)com>
Cc: Bruno Wolff III <bruno(at)wolff(dot)to>, pgsql-general(at)postgresql(dot)org
Subject: Re: GUIDs
Date: 2003-11-15 22:26:55
Message-ID: 87ekw9s1xs.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David Wheeler <david(at)kineticode(dot)com> writes:

> I can store them as a string in Perl, but the trick is getting the
> string representation in the first place. The library I was looking at
> using Data::UUID, offers binary and hex representations, as well as a
> 32 bit alphanumeric string and a Base64-encoded string, but not a
> numeric string, unfortunately.

I think if I were in your place, I'd store them as TEXT fields using
either the base64 or hex representation.

-Doug

In response to

  • Re: GUIDs at 2003-11-15 21:41:26 from David Wheeler

Responses

  • Re: GUIDs at 2003-11-15 23:21:25 from David Wheeler

Browse pgsql-general by date

  From Date Subject
Next Message Nigel J. Andrews 2003-11-15 22:57:10 Re: Conservation of OIDs
Previous Message Jan Wieck 2003-11-15 22:01:21 Re: UPGRADING 7.1 TO 7.3.4