Horton

Re: storing binary data

Lincoln Yeoh <lyeoh@pop.jaring.my>

View thread View on postgr.es
From: Lincoln Yeoh <lyeoh@pop.jaring.my>
To: Joe Conway <joseph.conway@home.com>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jason Orendorff <jason@jorendorff.com>, pgsql-hackers@postgresql.org
Date: 2001-10-25T08:56:29Z
Lists: pgsql-hackers 
>
>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.
>

Cool!

Would it be practical to use substring for retrieving chunks of binary data
in manageable sizes? Or would the overheads be too high?

Cheerio,
Link.