This repo has some useful Pl/PgSQL functions derived from those I wrote for my earlier projects. Will try to add more functions in the coming days. 1. PostGIS function to get a GeoJSON of polygon ...

This gem provides helpers for creating and removing PL/pgSQL functions and triggers within a PostgreSQL database. This is a wildly naïve implementation that has only been carried far enough to ease my ...

It is important not to confuse the use of BEGIN/END for grouping statements in PL/pgSQL with the database commands for transaction control. PL/pgSQL 's BEGIN/END are only for grouping; they do not ...

Example 19-2. A Simple PL/pgSQL Function to Increment an Integer The following two PL/pgSQL functions are identical to their counterparts from the C language function discussion. This function ...