Searching multi value (String) properties with SQL?

[gsoap <gs...@yahoo.com>]

Hi, 

How can we search multi value (String) properties with SQL? 

Thanks.
-- 
View this message in context: http://www.nabble.com/Searching-multi-value-%28String%29-properties-with-SQL--tf3863191.html#a10944113
Sent from the Jackrabbit - Dev mailing list archive at Nabble.com.

Re: Searching multi value (String) properties with SQL?

[Marcel Reutegger <ma...@day.com>]

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

Re: Searching multi value (String) properties with SQL?

[Jukka Zitting <ju...@gmail.com>]

Hi,

Again, please don't post the same message both to users@ and dev@.
This is a user question so it should be sent just to users@.

BR,

Jukka Zitting