News for hackers. Stuff that matters.
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

    WITH orders(created_at) AS (
      SELECT date '2012-01-01' UNION ALL
      SELECT date '2012-01-02' UNION ALL
      SELECT date '2012-01-03' UNION ALL
      SELECT date '2012-01-04' UNION ALL
      SELECT date '2012-01-05' UNION ALL
      SELECT date '2012-01-06' UNION ALL
      SELECT date '2012-01-07' UNION ALL
      SELECT date '2012-01-08'
    )
    SELECT EXTRACT(DOW FROM created_at) wkday, COUNT(1) 
    FROM orders
    GROUP BY wkday
That's really disturbing. I fixed the linked article accordingly.
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.

Re:Easy Steps to a Complete Understanding of SQL by lukaseder on Wednesday September 04, 2013 @03:58AM (#6326213)
You're right, the new wording was ambiguous. A better wording is this:

Rule number 2, for instance, does not apply exactly in the above way to MySQL, PostgreSQL, and SQLite.