jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "McComsey, Doug" <Doug.Mccom...@ca.com>
Subject Question on the IN operand of an SQL WHERE clause
Date Fri, 14 Oct 2005 15:17:27 GMT

The spec does not seem to define the IN operand of a WHERE clause of an SQL query.

It is mentioned in section 8.5.3 SQL EBNF:

  whereexp ::= propname op value |
               propname IS NULL |
               propname IS NOT NULL |
               value IN propname |         <== mentioned here
               like |
               contains |
               whereexp AND whereexp |
               whereexp OR whereexp |
               NOT whereexp |
               '(' whereexp ')'

Following that, in 8.5.4.3 WHERE, there is a description of the WHERE clause with no mention
of the IN parameter at all. I cannot find a description of what it means.

My question is: Are these two clauses identical?

  WHERE 'xyz' IN NAME
  WHERE NAME = 'xyz'

Or are these:

  WHERE 'xyz' IN NAME
  WHERE NAME LIKE '%xyz%'

Doug McComsey
Computer Associates
doug.mccomsey@ca.com
 



Mime
View raw message