From Seo Wiki - Search Engine Optimization and Programming Languages
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. Functions created in the PL/pgSQL language can be called from an SQL statement, or as the action that a trigger performs.
PL/pgSQL was created to be able to perform more complex operations and computations than SQL, while being easy to use, and is able to be defined as trusted by the server.
- ↑ "PL/pgSQL - SQL Procedural Language". http://www.postgresql.org/docs/current/static/plpgsql.html. Retrieved 2007-11-15.