Hacker News new | ask | show | jobs
by uhoh-itsmaciek 1577 days ago
Note that SQL-standard bodies are supported as of 14 [1]:

    Allow SQL-language functions and procedures to use SQL-standard function bodies (Peter Eisentraut)

    Previously only string-literal function bodies were supported. When writing a function or procedure in SQL-standard syntax, the body is parsed immediately and stored as a parse tree. This allows better tracking of function dependencies, and can have security benefits.
[1]: https://www.postgresql.org/docs/14/release-14.html
2 comments

can you declare and modify string literal functions inside sql standard functions?

if so that's form interpretation right, you could build a powerful lisp-style macro system that way I think.

Ah, that's good news. Thanks.