On 2/20/18, Etienne Sanchez <etiennesanch...@gmail.com> wrote:
>
> As for "left", it's maybe due to the ambiguity with "left join", but then
> what about "right"? (There is no ambiguity with "right join" since it is
> not supported.)
"left" and "right" are keywords in SQL. SQLite understands the RIGHT
keyword, even though it does not (yet) implement a RIGHT JOIN.
You can force any word to be an identifier by enclosing it in double quotes:
SELECT "left"('abc', 2);
And it that case, it gives the error message you were expecting.
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
