Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 70D106325C8 for ; Wed, 1 Jul 2009 13:51:08 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 86568-05 for ; Wed, 1 Jul 2009 13:51:04 -0300 (ADT) X-Greylist: delayed 00:09:49.610411 by SQLgrey-1.7.6 Received: from AZ25EGS04.gdc4s.com (az25egs04.gdc4s.com [63.226.32.83]) by mail.postgresql.org (Postfix) with ESMTP id 6CDF46332C0 for ; Wed, 1 Jul 2009 13:51:05 -0300 (ADT) Received: from unknown (HELO az25ege01.gdc4s.com) ([192.168.2.21]) by AZ25EGS04.gdc4s.com with ESMTP; 01 Jul 2009 09:36:00 -0700 X-TM-IMSS-Message-ID: Received: from az25egi01 ([10.240.12.60]) by gdc4s.com ([192.168.2.21]) with ESMTP (TREND IMSS SMTP Service 7.0) id e79e7f1d000b4619 ; Wed, 1 Jul 2009 09:36:37 -0700 X-TM-IMSS-Message-ID: <1d07449a00039984@gddsi.com> Received: from az25exf03.gddsi.com ([10.240.12.50]) by gddsi.com ([10.240.12.60]) with ESMTP (TREND IMSS SMTP Service 7.0) id 1d07449a00039984 ; Wed, 1 Jul 2009 09:40:52 -0700 Received: from AZ25EXM01.gddsi.com ([10.240.10.172]) by az25exf03.gddsi.com with Microsoft SMTPSVC(6.0.3790.3959); Wed, 1 Jul 2009 09:41:12 -0700 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C9FA6A.BE3F7363" Subject: Xpath() return xml[] Date: Wed, 1 Jul 2009 09:40:54 -0700 Message-ID: <2B0195B08BA41748A38C4D58ADF44F2C037BAC7D@AZ25EXM01.gddsi.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Xpath() return xml[] Thread-Index: Acn6arOghAsZKLi/TTuw4Wl5TArAog== From: "Tamayo, Damian-p65828" To: X-OriginalArrivalTime: 01 Jul 2009 16:41:12.0054 (UTC) FILETIME=[BE280160:01C9FA6A] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200907/3 X-Sequence-Number: 32744 This is a multi-part message in MIME format. ------_=_NextPart_001_01C9FA6A.BE3F7363 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi,=20 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????=20 Example of output: Id | xml[] 1 | 2 | 3 | {} 4 | {} =20 Etc..... I want to only return the rows that did not return {}=20 Any help with this would be appreciated....=20 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. ------_=_NextPart_001_01C9FA6A.BE3F7363 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Xpath() return xml[]

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.

------_=_NextPart_001_01C9FA6A.BE3F7363--