| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Mark Mielke <mark(at)mark(dot)mielke(dot)cc> |
| Cc: | Kless <jonas(dot)esp(at)googlemail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: UUID - Data type inefficient |
| Date: | 2008-07-10 16:13:33 |
| Message-ID: | 1215706413.10376.176.camel@jd-laptop |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 2008-07-10 at 12:05 -0400, Mark Mielke wrote:
> Mark Mielke wrote:
> > I didn't notice that he put 16. Now I'm looking at uuid.c in
> > PostgreSQL 8.3.3 and I see that it does use 16, and the struct
> > pg_uuid_t is length 16. I find myself confused now - why does
> > PostgreSQL define UUID_LEN as 16?
> >
> > I will investigate if I have time tonight. There MUST be some mistake
> > or misunderstanding. 128-bit numbers should be stored as 8 bytes, not 16.
>
> Grrrr.... Kless you've confused me. 32-bit numbers = 4 bytes, 64-bit
> numbers = 8 bytes, 128-bit numbers = 16 bytes.
>
> You are out to lunch and you dragged me with you. Did we have beer at
> least? :-)
Sounds like at least 4 and a couple of chasers.
>
> Cheers,
> mark
>
> --
> Mark Mielke <mark(at)mielke(dot)cc>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David E. Wheeler | 2008-07-10 16:38:54 | Re: UUID - Data type inefficient |
| Previous Message | Aidan Van Dyk | 2008-07-10 16:09:42 | Re: WITH RECURSIVE updated to CVS TIP |