When I select the PostgreSQL data source in my workflow and use the non-query type to execute the following PL/pgSQL script: DO $DO$ DECLARE offset_value INTEGER := 0 ...
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 ...