Re: storing binary data - Mailing list pgsql-hackers

From Joe Conway
Subject Re: storing binary data
Date
Msg-id 3BD66553.2000706@home.com
Whole thread Raw
In response to storing binary data  ("Jason Orendorff" <jason@jorendorff.com>)
Responses Re: storing binary data
Re: storing binary data
List pgsql-hackers
>> + What I really need is a binary *short* object type.
>>   I have heard rumors of a legendary "bytea" type that might
>>   help me, but it doesn't appear to be documented anywhere,
>>   so I hesitate to use it.
>>
> 
> It's real and it's not going away.  It is pretty poorly documented
> and doesn't have a wide variety of functions ... but hey, you can help
> improve that situation.  This is an open source project after all ;-)
> 
>             regards, tom lane

I'll take a shot at improving the documentation for bytea. I'm hoping 
documentation patches are accepted during beta though ;-)

Also, FWIW, 7.2 includes bytea support for LIKE, NOT LIKE, LIKE ESCAPE, 
||, trim(), substring(), position(), length(), indexing, and various 
comparators.

Joe



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: LOCK ROW SHARE MODE
Next
From: David Ford
Date:
Subject: PQconnectStart() and -EINTR