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