Miroslav Nachev wrote:
Most of the popular databases (Oracle, MySQL, MS SQL, etc.) support binary column type which can be used as primary key. For example UUID algorithm need of exact 16 bytes and is very useful for Primary Key. Of course it can be presented with characters in Hex format but in that case this will take 32 bytes which is 2 times bigger. It will be very helpful if in PostgreSQL binary/varbinary type is supported and can be used for indexes and primary keys.
There's a built-in UUID datatype that you might be interested in. It's 16 bytes, fixed-length.
Also, what's wrong with bytea? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
