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

PostgreSQLでは，いろいろな言語を使ってユーザー定義関数を書くことができる。代表的なものとしては，PL/pgSQLというSQLに ...

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

インプレスグループで電子出版事業を手がける株式会社インプレスR&Dは、『わたしとぼくのPL/pgSQL』（著者：目黒 聖）を ...

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.

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