3 ms·
any good resources for going deeper on the analytical capabilities of postgres? ya know, beyond basic window functions. How can i leverage stored procs etc?
by Wonnk13 9y ago
any good resources for going deeper on the analytical capabilities of postgres? ya know, beyond basic window functions. How can i leverage stored procs etc?
- cpburns2009 9y agoLook into PL/pgSQL [1]. PostgreSQL also offers a few other languages such as Python and Perl [2]. Please note that the individual extensions have to be installed. [1]: https://www.postgresql.org/docs/current/static/plpgsql.html https://www.postgresql.org/docs/current/static/plpgsql.html [2]: https://www.postgresql.org/docs/current/static/server-programming.html https://www.postgresql.org/docs/current/static/server-progra...