Received: from cda.mrs.umn.edu (root@cda.mrs.umn.edu [146.57.3.11])
	by hub.org (8.10.1/8.10.1) with ESMTP id e6ILF9h11422
	for <pgsql-interfaces@postgresql.org>;
	Tue, 18 Jul 2000 17:15:09 -0400 (EDT)
Received: from netasol.com (ctrts1-3.mrs.umn.edu [146.57.4.203])
	by cda.mrs.umn.edu (8.10.0/8.10.0) with ESMTP id e6ILF7125724
	for <pgsql-interfaces@postgresql.org>;
	Tue, 18 Jul 2000 16:15:08 -0500 (CDT)
Message-ID: <3974C8EB.851DE425@netasol.com>
Date: Tue, 18 Jul 2000 16:15:24 -0500
From: Matt Fair <matt@netasol.com>
Organization: Netasol Networks, Inc.
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Searching Blobs
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200007/131

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