Hi Chemistries,
I am confused about the spec regarding query with multi-value properties. I understand that a plain IN is only another syntax for OR and restricted to single value properties: WHERE myprop IN ['red', 'green', 'blue'] The spec is also quite clear about IN ANY for multi-value properties: WHERE ANY mycolors in ['red', 'green', 'blue'] (matches if at least one of the values in mycolors is either red or green or blue) But is there any difference to the following statement? WHERE ['red', 'green', 'blue'] = ANY mycolors Is this only syntactic sugar? Former versions of the spec have supported more operators (<, > etc. ) where this might have made more sense? The spec has both examples but does not really explain them. Jens
