Ok, I'm going to do a review of this article, which is the subject of my long-term interest. Link will be in comments below. PostgreSQL functions are powerful tools that allow developers to ...

Here are only a few functions to demonstrate how easy it is to write PL/pgSQL functions. For more complex examples the programmer might look at the regression test for PL/pgSQL.

PL/pgSQL, as a fully featured programming language, allows much more procedural control than SQL, including the ability to use loops and other control structures. SQL statements and triggers can call ...