3 ms·
> Stored procedures are just that - they get a name and persistence. PLSQL has procedural extensions, but it is still SQL. PostgreSQL distributions come with s
by dancek 10y ago
> Stored procedures are just that - they get a name and persistence. PLSQL has procedural extensions, but it is still SQL.
PostgreSQL distributions come with support for PL/Python, PL/Tcl, PL/Perl and PL/pgSQL (a PostgreSQL specific PL/SQL clone). Other languages exist, but aren't included. See https://www.postgresql.org/docs/9.6/static/external-pl.html https://www.postgresql.org/docs/9.6/static/external-pl.html
- __jal 10y agoYes. And PL/Perl is perversely fun. I don't think I've ever seen other languages used in production, though[1]; I think folks tend to stick to PLSQL because of defaults. [1] I'm sure people do, but this discussion has an anecdata deficiency.