GitHub

PostgreSQL - auto manage positions with a trigger

Trigger position is a PostgreSQL trigger function that can simply manage your position/ordering columns for your tables. This trigger function guarantees unbroken number series for your positions (1, ...
GitHub

DotNetBrightener/postgres-temporal_tables

This rewrite aims to provide a temporal tables solution in PL/pgSQL, targeting AWS RDS, Google Cloud SQL, and Azure Database for PostgreSQL where custom C extensions aren't permitted. The script in ...
www.cs.cmu.edu

PostgreSQL 7.3.2 Programmer's Guide

19-2. A Simple PL/pgSQL Function to Increment an Integer 19-3. A Simple PL/pgSQL Function to Concatenate Text 19-4. A PL/pgSQL Function on Composite Type ...
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 ...