steve.dignam.xyz
Surprises in Postgres SQL
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.