I have created a fixed length octet string type which anyone so inclined
should feel free to use. The purpose of this type is to reduce the
overhead associated with storing fixed length binary data in a variable
length type like bytea. So far, I've implemented a sixteen octet string
type, which would be appropriate for storing MD5 hashes or UUID's (aka
GUID's), say. I plan to implement other common sizes.
http://www.yellowbank.com/code/PostgreSQL/y_octet_t/
Comments or suggestions for improvement are very welcome.
Best.
--
Ron Peterson
https://www.yellowbank.com/