Skip site navigation (1) Skip section navigation (2)

Re: storing binary data

From: Joe Conway <joseph(dot)conway(at)home(dot)com>
To: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: storing binary data
Date: 2001-10-28 01:02:57
Message-ID: 3BDB5941.5050303@home.com (view raw or flat)
Thread:
Lists: 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


In response to

pgsql-hackers by date

Next:From: Bill StudenmundDate: 2001-10-28 03:31:09
Subject: Correct way to do deletes?
Previous:From: Bill StudenmundDate: 2001-10-28 00:46:03
Subject: Re: Proposed new create command, CREATE OPERATOR CLASS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group