Surprises in Postgres SQL
kept by solwind
The article details surprising PostgreSQL SQL quirks: alias column pass‑through, ambiguous table/column names, interchangeable function/column syntax, multiple cast styles, composite types, table‑returning functions, and type coercion oddities.