Re: UUID - Data type inefficient

Поиск
Список
Период
Сортировка
От Mark Mielke
Тема Re: UUID - Data type inefficient
Дата
Msg-id 4876333F.7080005@mark.mielke.cc
обсуждение исходный текст
Ответ на Re: UUID - Data type inefficient  (Mark Mielke <mark@mark.mielke.cc>)
Ответы Re: UUID - Data type inefficient  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: UUID - Data type inefficient  (Kaare Rasmussen <kaare@jasonic.dk>)
Список pgsql-hackers
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? :-)

Cheers,
mark

-- 
Mark Mielke <mark@mielke.cc>



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: UUID - Data type inefficient
Следующее
От: Aidan Van Dyk
Дата:
Сообщение: Re: WITH RECURSIVE updated to CVS TIP