Lincoln Yeoh wrote:
>>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.
I haven't done any performance testing, but it should be no different
than the substring function used on TEXT fields. Try it out and let us
know ;-)
-- Joe