jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marcel Reutegger <marcel.reuteg...@day.com>
Subject Re: Searching multi value (String) properties with SQL?
Date Mon, 04 Jun 2007 08:09:32 GMT
gsoap wrote:
> How can we search multi value (String) properties with SQL? 

as per the specification the operators in SQL behave all like XPath general 
comparison.

e.g. if you have a node n with a property p with values {1, 2, 3}

select * from nt:base where p = 2

will return the node n, but also the following query will return node n:

select * from nt:base where p <> 2

regards
  marcel

Mime
View raw message