Re: Querying a BYTEA datatype

Thanks Merlin

On 4/15/06, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
>
> On 4/14/06, Shoaib Mir <shoaibmir(at)gmail(dot)com> wrote:
> > Hi All,
> >
> > Need an urgent help on the following:
> >
> > How can in PostgreSQL we handle quries on the content of bytea data
> type?
> >
> > Like if we want to do some search on the basis of bytea content, is
> there a
> > way?
> >
>
> you have two options that i know of:
> 1. convert to text and do text processing
> 2. make a c function that processes binary and link it to the server.
> this will probably give you the best performance
>