Re: storing binary data
Joe Conway <joseph.conway@home.com>
From: Joe Conway <joseph.conway@home.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jason Orendorff <jason@jorendorff.com>, pgsql-hackers@postgresql.org
Date: 2001-10-24T06:53:07Z
Lists: pgsql-hackers
>> + What I really need is a binary *short* object type. >> I have heard rumors of a legendary "bytea" type that might >> help me, but it doesn't appear to be documented anywhere, >> so I hesitate to use it. >> > > It's real and it's not going away. It is pretty poorly documented > and doesn't have a wide variety of functions ... but hey, you can help > improve that situation. This is an open source project after all ;-) > > regards, tom lane I'll take a shot at improving the documentation for bytea. I'm hoping documentation patches are accepted during beta though ;-) Also, FWIW, 7.2 includes bytea support for LIKE, NOT LIKE, LIKE ESCAPE, ||, trim(), substring(), position(), length(), indexing, and various comparators. Joe