Re: storing binary data

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: storing binary data
Дата
Msg-id 3BDB5941.5050303@home.com
обсуждение исходный текст
Ответ на storing binary data  ("Jason Orendorff" <jason@jorendorff.com>)
Список pgsql-hackers
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



В списке pgsql-hackers по дате отправления: