Обсуждение: Querying a BYTEA datatype

Поиск
Список
Период
Сортировка

Querying a BYTEA datatype

От
"Shoaib Mir"
Дата:
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?

/Shoaib

Re: Querying a BYTEA datatype

От
"Merlin Moncure"
Дата:
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

Re: Querying a BYTEA datatype

От
"Shoaib Mir"
Дата:
Thanks Merlin

On 4/15/06, Merlin Moncure <mmoncure@gmail.com> wrote:
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