Hi, I'd like to know what the official recommendation is on which binary datatype to use for common small-binary size use.
I'm working with the Open For Business (www.ofbiz.org) framework, which by default maps binary data, such as shipping label images, into OID field types. In general, the data is far less than a gigabyte in size. Is it strongly recommended by the postgresql community to store things like this in bytea format as of 8.0? Thanks, Leon Torres [EMAIL PROTECTED] Open Source Strategies http://opensourcestrategies.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match