On 6/4/2012 1:25 PM, Wolfgang Meiners wrote:
Am 04.06.12 18:59, schrieb Igor Tandetnik:
On 6/4/2012 12:33 PM, Wolfgang Meiners wrote:
this trigger does work but i think it is not in accordance with the
syntax diagram of TRIGGER on
http://sqlite.com/lang_createtrigger.html
Which part do you feel is in violation of the diagram?
I cant find anything about
SELECT CASE
...
END;
in the diagram
The diagram allows a select-stmt. So looking at
http://sqlite.org/lang_select.html, we can have "SELECT result-column
..." and result-column could be an expr. Looking at
http://sqlite.org/lang_expr.html, one possibility for expr is a CASE ...
END clause.
and i dont understand, how it works. Can there be just one
WHEN ...
THEN ...
part or more then one?
More than one.
Is it possible to have something
like
IF ...
THEN ...
too?
No.
This seems to be an programming language, but i have not found the rules
for this language.
http://sqlite.org/lang.html
http://sqlite.org/syntaxdiagrams.html
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users