Databases

Lobsters · May 15, 2026 13:58

Welcome to ORDER BY jungle

Bare names and expressions in ORDER BY go through two different parsers in PostgreSQL. The boundary between them is one if-statement old enough to vote, and it shows up in places you would not expect.

Topics: Databases

Entities: Databases