From: Tamayo, Damian-p65828 <Damian.Tamayo@gdc4s.com>
To: pgsql-sql@postgresql.org
Subject: Xpath() return xml[]
Date: Wed, 1 Jul 2009 09:40:54 -0700
Message-ID: <2B0195B08BA41748A38C4D58ADF44F2C037BAC7D@AZ25EXM01.gddsi.com> (raw)
Hi,
I have been developing in postgresql for a very short time. I am
currently having problems that I believe can be resolved with the right
query structure but as of yet have not been able to figure it out.
I am using xpath(xpathExpression, xml, Array[Array[]]) function form
8.3.7 (This is the version that I am currently implementing)
This function returns an xml[] ... However, the problem is that in the
xml array return I get the valid return values that I am looking for but
I also get empty sets. How can I return only the sets that returned
valid????
Example of output:
Id | xml[]
1 | <Root/>
2 | <Root/>
3 | {}
4 | {}
Etc.....
I want to only return the rows that did not return {}
Any help with this would be appreciated....
Thank you.
Damian Tamayo
General Dynamics C4 Systems
This email message is for the sole use of the intended recipient(s) and
may contain GDC4S confidential or privileged information. Any
unauthorized review, use, disclosure is prohibited. If you are not an
intended recipient, please contact the sender by reply email and destroy
all copies of the original message.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Damian.Tamayo@gdc4s.com
Subject: Re: Xpath() return xml[]
In-Reply-To: <2B0195B08BA41748A38C4D58ADF44F2C037BAC7D@AZ25EXM01.gddsi.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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