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/
