This is an attempt to make a MSSQL's T-SQL to PostgreSQL's PL/pgSQL converter based on Poor Man's T-SQL Formatter. It's using the unchanged parser and slightly changed formatter, as well as adding an ...

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

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

Here are only a few functions to demonstrate how easy it is to write PL/pgSQL functions. For more complex examples the programmer might look at the regression test for PL/pgSQL.