<p><font face="Arial" size="2">Hi, </font><br /><font face="Arial" size="2">I have been developing in postgresql for a
veryshort time. I am currently having problems that I believe can be resolved with the right query structure but as of
yethave not been able to figure it out.</font><p><font face="Arial" size="2">I am using xpath(xpathExpression, xml,
Array[Array[]])function form 8.3.7 (This is the version that I am currently implementing)</font><p><font face="Arial"
size="2">Thisfunction returns an xml[] … However, the problem is that in the xml array return I get the valid return
valuesthat I am looking for but I also get empty sets. How can I return only the sets that returned valid????
</font><p><fontface="Arial" size="2">Example of output:</font><p><font face="Arial" size="2">Id |
xml[]</font><br/><font face="Arial" size="2">1 | <Root/></font><br /><font face="Arial"
size="2">2 | <Root/></font><br /><font face="Arial" size="2">3 | {}</font><br /><font face="Arial"
size="2">4 | {} </font><br /><font face="Arial" size="2">Etc…..</font><p><font face="Arial" size="2">I want to
onlyreturn the rows that did not return {} </font><p><font face="Arial" size="2">Any help with this would be
appreciated….</font><p><font face="Arial" size="2">Thank you.</font><p><font color="#800080" face="Brush Script MT"
size="5">DamianTamayo</font><br /><font face="Arial" size="2">General Dynamics C4 Systems</font><p><font face="Arial"
size="1">Thisemail message is for the sole use of the intended recipient(s) and may contain GDC4S confidential or
privilegedinformation. Any unauthorized review, use, disclosure is prohibited. If you are not an intended recipient,
pleasecontact the sender by reply email and destroy all copies of the original message.</font>