Sorry my example is wrong. The last example is syntactically incorrect. It must be:
WHERE 'red'= ANY mycolors But the question remains: Is it different to WHERE ANY mycolors in ['red'] -----Original Message----- From: Jens Hübel [mailto:[email protected]] Sent: Donnerstag, 17. Juni 2010 15:13 To: [email protected] Subject: Query with ANY 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
