Re: Querying a BYTEA datatype - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Querying a BYTEA datatype
Date
Msg-id b42b73150604141516p5270a0c6x469a2f1c8eb28676@mail.gmail.com
Whole thread Raw
In response to Querying a BYTEA datatype  ("Shoaib Mir" <shoaibmir@gmail.com>)
Responses Re: Querying a BYTEA datatype  ("Shoaib Mir" <shoaibmir@gmail.com>)
List pgsql-general
On 4/14/06, Shoaib Mir <shoaibmir@gmail.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

pgsql-general by date:

Previous
From: "Shoaib Mir"
Date:
Subject: Querying a BYTEA datatype
Next
From: "Sam Thukral"
Date:
Subject: Fetch in select statement