| From: | Tim Landscheidt <tim(at)tim-landscheidt(dot)de> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Comparing a string against an XPath result set |
| Date: | 2009-07-16 21:19:56 |
| Message-ID: | m3ljmocolf.fsf@passepartout.tim-landscheidt.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi,
I'm trying to check whether a given string is part of an
XPath result set. I have encountered some performance prob-
lems in the process, but before I track those down further,
I'd like to see if I've chosen the right path to begin with:
| SELECT * FROM $TABLE
| WHERE $COLUMN = ANY((xpath($EXPR, xmlparse(DOCUMENT $DOC)))::TEXT[]);
In this case, xpath() returns an array of XML fragments made
of a "pure" text child each. I cannot compare XML fragments
with anything, so the conversion to TEXT[] seems to be the
only way I could check whether $COLUMN is a part of those.
Is there any other way I could tackle this?
Tim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christophe | 2009-07-17 03:07:09 | De-duplicating rows |
| Previous Message | Emi Lu | 2009-07-14 18:52:38 | Re: Request new version to support "on commit drop" for create temp table ... as select ? |