5mins of Postgres E27: Waiting for Postgres 16 - Make subquery alias optional in FROM clause
Today, we are talking about a change in Postgres 16, that removes the alias requirement for subqueries in FROM. This may seem like a very obscure problem, but it's actually a very common issue for people that either migrate to Postgres or who are new to Postgres and run into this error.
Find the article on our blog here: https://pganalyze.com/blog/5mins-post...
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
📑 What we have discussed in this episode of 5mins of Postgres:
Postgres error: "subquery in FROM must have an alias" https://pganalyze.com/docs/log-insigh...
StackOverflow: subquery in FROM must have an alias https://stackoverflow.com/questions/1...
pgsql-hackers: Make subquery alias optional in FROM clause (2017) https://www.postgresql.org/message-id...
Bernd Helmle on Twitter / berndhelmle
Postgres source code: gram.y https://github.com/postgres/postgres/...
pgsql-hackers: Making the subquery alias optional in the FROM clause (2022) https://www.postgresql.org/message-id...
Postgres commit: Make subquery aliases optional in the FROM clause https://git.postgresql.org/gitweb/?p=...