Get the latest tech news
Interesting Bits of Postgres Grammar
Lessons from building a parser
Meaning the order by clause is applied to the overall compound select. You can also prefix quoted identifiers with U& and pass unicode escape codes: Overall, I think custom operators diverge the most from other mainstream languages and can be tricky to implement.
Or read this on Hacker News