Re:Easy Steps to a Complete Understanding of SQL
by lukaseder on Tuesday September 03, 2013 @11:03AM
(#6321351)
Aagh, it works indeed in PostgreSQL: http://sqlfiddle.com/#!12/d41d8/1585
That's really disturbing. I fixed the linked article accordingly.
[ Parent
| on HN ]
Re:Easy Steps to a Complete Understanding of SQL
by jcampbell1 on Tuesday September 03, 2013 @11:40AM
(#6321554)
You fixed the article incorrectly. SELECT aliases are never available in a WHERE clause.
Edit: it seems more complicated that I initially assumed. MySQL doesn't allow it. SQLite does.