RE: Searching Blobs

There may be something in contrib to handle this. Also UDM indexes web pages
so it must handle this senario somehow (not really looked too deeply into
it).

Also the Text/Toast stuff may also handle this, but thats not in until a
near future release.

Peter

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council

-----Original Message-----
From: Matt Fair [mailto:matt(at)netasol(dot)com]
Sent: Tuesday, July 18, 2000 10:15 PM
To: pgsql-interfaces(at)postgresql(dot)org
Subject: [INTERFACES] Searching Blobs

I have placed strings in blobs and stored them into the database, the
people who helped me thank you. I am using JDBC and I want to be able
to search these blobs for sub strings with a sql query and get a result
set back. Is this possible or would I have to have java or some other
language parse through all blobs that I get back after I convert them
back to strings? If this is so, it would be horribly inefficient.
Thanks
Matt Fair