In postgres 8.4 When running xpath() queries it
seems that empty results are always returned. So if I query a table
containing 1000 XML documents a 1000 rows will always be fetched even
if the xpath() element of the query only matches 10 documents. The documentation states: The functionYet it seems that empty node sets (arrays) are also returned. So, my thought was to run a subquery to eliminate empty arrays, e.g.: SELECT xHow do I test for an empty array in postgres? Thanks in advance, Roy |