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: (view raw, whole thread or download thread mbox)
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 
> 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-2017 The PostgreSQL Global Development Group