--- Tomash Brechko <[EMAIL PROTECTED]> wrote: > On Fri, May 11, 2007 at 09:57:01 +0100, Matteo > Vescovi wrote: > > Hi, > > I am getting weird results when executing a query > that > > has this WHERE clause: WHERE word = "word". > > > > The query works fine if I use WHERE word = 'word'. > > The WHERE word = "word" is a no-op. From "SQLite > Keywords" section of > http://www.sqlite.org/lang.html: > > 'keyword' A keyword in single quotes is > interpreted as a literal > string if it occurs in a context where a > string literal is > allowed, otherwise it is understood as > an identifier. > > "keyword" A keyword in double-quotes is > interpreted as an identifier > if it matches a known identifier. > Otherwise it is > interpreted as a string literal. >
That explains it. I was missing something, after all. Thanks for pointing me to the documentation and sorry for the noise. - Matteo > > -- > Tomash Brechko > > ----------------------------------------------------------------------------- > To unsubscribe, send email to > [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > ___________________________________________________________ Yahoo! Mail is the world's favourite email. Don't settle for less, sign up for your free account today http://uk.rd.yahoo.com/evt=44106/*http://uk.docs.yahoo.com/mail/winter07.html ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------