Hi, Vertica 11 is generally available with support for stored procedures written in PL-pgSQL. Please see our documentation here:
It's possible to write an external procedure, which is a script loaded onto Vertica servers to execute SQL scripts, but you may find the new PL-pgSQL stored procedure support to be much more familiar. If you have a current license or support account, you should contact your representative for technical advice on the different options.0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.