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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
