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

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

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