RE: Re: New data type: uniqueidentifier

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема RE: Re: New data type: uniqueidentifier
Дата
Msg-id ECEHIKNFIMMECLEBJFIGKECECBAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: New data type: uniqueidentifier  (Thomas Swan <tswan@olemiss.edu>)
Список pgsql-hackers
> don't create a bazillion datatypes.  Besides, 128 bit numbers are 7
> byte integers.

Hang on:  128 div 8 = 16 byte integer

> PostgreSQL has an int8 (8 byte integer) datatype.

And therefore it is a _64_ bit integer and you can't have a 256bit unique
number in it...

> While I like the UUID function idea, I'd recommend a better solution to
> creating an "unique" identifier.  Why not create a serial8 datatype:
> int8 with an int8 sequence = 256bit "unique" number.  {Yes, I know
> violating my first sentence.}  Then, you'd have the same thing (or
> better) AND your not relying on randomness.

Chris



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Buffer access rules, and a probable bug
Следующее
От: Tom Lane
Дата:
Сообщение: Re: selecting from cursor