Hi All! I've ported uniqueidentifier datatype to upcoming PostgreSQL 7.3. It's available at http://www.taurussoft.org/files/uniqueidentifier-0.1.9.3.tar.gz In this release there is additional function uniqueidentifier_text() which converts uniqueidentifier to text datatype. Thanks to Hussein Patni! Version for 7.2.X is available at http://www.taurussoft.org/files/uniqueidentifier-0.1.9.2.tar.gz Version for 7.1.X is available at http://www.taurussoft.org/files/uniqueidentifier-0.1.9.1.tar.gz The only difference between two releases is adoptation to 7.2.X system catalog. No new functions/bugfixes.
Uniqueidentifier datatype is 128-bit (16 byte) wide datatype claims to be unique across Universe. It's a good choice for primary indexes and making relations between tables. This inplementation depends on libuuid library from e2fsprogs package by Theodore Ts'o. Licence is LGPL. Regards, Dmitry ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])