pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Searching Blobs 2+ messages / 2 participants [nested] [flat]
* Searching Blobs @ 2000-07-18 21:15 Matt Fair <matt@netasol.com> 0 siblings, 0 replies; 2+ messages in thread From: Matt Fair @ 2000-07-18 21:15 UTC (permalink / raw) To: pgsql-interfaces 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* RE: Searching Blobs @ 2000-07-19 06:59 Peter Mount <petermount@it.maidstone.gov.uk> 0 siblings, 0 replies; 2+ messages in thread From: Peter Mount @ 2000-07-19 06:59 UTC (permalink / raw) To: 'Matt Fair' <matt@netasol.com>; pgsql-interfaces 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@netasol.com] Sent: Tuesday, July 18, 2000 10:15 PM To: pgsql-interfaces@postgresql.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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-07-19 06:59 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2000-07-18 21:15 Searching Blobs Matt Fair <matt@netasol.com> 2000-07-19 06:59 RE: Searching Blobs Peter Mount <petermount@it.maidstone.gov.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox