GitHub

dschnedar/Postgres-PL-pgSQL-Binary-Search-Tree

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

PL/pgSQL

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

SQL and PL/pgsql implementation of Shortest Path Dijkstra algorithm. Version for same length edge length (social network) for PostgreSQL server.

In his very interesting post "Benchmark: PostgreSQL, MongoDB, Neo4j, OrientDB and ArangoDB" (https://www.arangodb.com/2015/10/benchmark-postgresql-mongodb-arangodb ...
www.cs.cmu.edu

19.2. Structure of PL/pgSQL

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