I created a binary search tree to learn and practice PL/pgSQL. It was complicated enough to get a feel for PL/pgSQL. I found that PL/pgSQL forced me to use database tables to store the tree nodes even ...

Usually databases are treated primarily as fairly dumb data storage systems, but they can be capable of much more. Case in point the PostgreSQL database and its – Ada-based – PL/pgSQL programming ...

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 ...