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

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

This commit adds a parse-time check that the labels on a PLpgSQL block (if any) match. If the labels do not match, an expected syntax error is returned. This commit ...

Any statement in the statement section of a block can be a sub-block. Sub-blocks can be used for logical grouping or to localize variables to a small group of statements. The variables declared in the ...