New data type: uniqueidentifier
От | Dmitry G. Mastrukov |
---|---|
Тема | New data type: uniqueidentifier |
Дата | |
Msg-id | 000d01c0fe7a$753a63c0$016ba8c0@taurussoft.org обсуждение исходный текст |
Ответы |
Re: New data type: uniqueidentifier
Re: New data type: uniqueidentifier |
Список | pgsql-hackers |
Hi, All! I've developed new data type for PostgreSQL - uniqueidentifier - 128-bit value claims to be unique across Universe. It depends on libuuid from e2fsprogs by Theodore Ts'o. Now I use it in my project. Everybody can grab it from http://taurussoft.chat.ru/uniqueidentifier-0.1.9.tar.gz Before announce this new type through pgsql-announce I want to clear for myself some things. I've marked "=" operator with HASH clause (and planner has started to use hash jons). But as I understand the right way is to create special hash function (may be wrapper for hash_any(), isn't it?) and register it for hash as for btree method. So is it desirable to mark "=" as HASH for this type (seems internal 16 byte representation will be hash well) and if yes how can I create hash sort method for uniqueidentifier? regards, Dmitry PS. If you decide to install uniqueidentifier look at the date of uuid/uuid.h somewhere in INCLUDE path. Sometimes it's necessary to manualy enter "make install" in lib/uuid directory of e2fsprogs.
В списке pgsql-hackers по дате отправления: