3 ms·
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
by uhoh-itsmaciek 5y 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 https://www.postgresql.org/docs/14/release-14.html
- giraffe_lady 5y agocan 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.
- radiowave 5y agoAh, that's good news. Thanks.