On June 11, rick wrote:
Yes, it can be explained: <http://www.sqlite.org/lang_keywords.html> says:
'keyword' A keyword in single quotes is a string literal.
"keyword" A keyword in double-quotes is an identifier
So, "id" is interpreted as a column name, not as the string literal 'id',
unless the value in the double quotes is not an identifier (column name).
You have overstated the requirements upon SQL identifiers. Quoting via
surrounding double-quote is only necessary if the identifier would not meet
the definition of a "regular identifier", loosely understood to be a letter
followed by letter, digit or underscore characters. Hence, the text "id"
without any quotes would be a valid SQL identifier.
From http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt :
<actual identifier> ::=
<regular identifier>
| <delimited identifier>
<regular identifier> ::= <identifier body>
<identifier body> ::=
<identifier start> [ { <underscore> | <identifier part>
}... ]
<identifier start> ::= !! See the Syntax Rules
<identifier part> ::=
<identifier start>
| <digit>
1) An <identifier start> is one of:
a) A <simple Latin letter>; or
b) A character that is identified as a letter in the character
repertoire identified by the <module character set specifica-
tion> or by the <character set specification>; or
c) A character that is identified as a syllable in the char-
acter repertoire identified by the <module character set
specification> or by the <character set specification>; or
d) A character that is identified as an ideograph in the char-
acter repertoire identified by the <module character set
specification> or by the <character set specification>.
--
Larry Brasfield
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
