On 4/14/06, Shoaib Mir <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly