jackrabbit-oak-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Mueller <muel...@adobe.com>
Subject Converting XPath to SQL-2
Date Tue, 03 Apr 2012 10:40:39 GMT
Hi,

I wonder how to best convert the following XPath query to SQL-2:

    //*[@test='hello']

First I thought it would be:

    select * from [nt:base] where [test]='hello' and isdescendantnode('/')

but this is incorrect, as the SQL-2 query excludes the root node, while the XPath query includes
the root node.

How would the SQL-2 query look like to match the XPath query?

Regards,
Thomas


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message