Miroslav Nachev wrote:
And how to specify that bytea MUST be exact 16 bytes?
Well, you could put a constraint on the column, or create a domain with such a constraint. But if you're dealing with uuids, you really want to use the UUID data type anyway.
What about the speed because this is very important? 1st of all when the length is variable then the speed is low.
The overhead is small enough that you'd never notice.
2nd when the column is with bigger length which require pointer to the data instead data, then the speed will be extremely low.
Again you're just assuming some overhead that's completely insignificant in the big scheme of things.
-- 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
