Interesting Bits of Postgres Grammar

58 sbdchd 4 6/23/2025, 3:09:21 PM steve.dignam.xyz ↗

Comments (4)

o11c · 21m ago
Postgres's identifier-quoting is almost what standard SQL requires, except that it folds in the wrong direction (only relevant if you're introspecting or mixing quoted with unquoted identifiers).

Many (Most?) other SQL implementations violate the standard horribly.

PaulHoule · 25m ago
What I want is a PEG grammar generator that lets you set operator precedence with either numbers or partial orderings.
lovich · 3h ago
Was not aware you can execute lambda calculus in sql. neat article
cryptonector · 16m ago
SQL is Turing complete.