Description:
You write SELECT first. Postgres runs it fifth, after FROM, WHERE, GROUP BY and HAVING.
That's why an alias from SELECT fails in WHERE and works in ORDER BY.
Code and measurements: github.com/Sun-Deep/coding-chops
#sql #postgresql #database #programming #coding
Share this link via
Or copy link























