Frontier Software

Postgresql

Documentation

Client Applications

Utilities

Wrappers

Server Applications

types

manual Numeric Monetary Character Binary Date/Time Boolean AND, OR, NOT Comparison Enumerated Geometric Network Address Bit String Text Search UUID XML JSON Functions Arrays Composite Range Domain Object Identifier pg_lsn Pseudo

plpgsql

CREATE OR REPLACE FUNCTION My Style RETURN vs OUT parameters Postgresql functions can either be written CREATE OR REPLACE FUNCTION add(a integer, b integer) RETURNS integer LANGUAGE plpgsql AS $code$ BEGIN RETURN a + b; END; $code$; Alternatively, it can be written in a more Prologish style with parameters labeled IN or OUT (or INOUT). CREATE OR REPLACE FUNCTION add(IN a integer, IN b integer, OUT c integer) LANGUAGE plpgsql AS $code$ BEGIN c = a + b; END; $code$; Since most of the functions for my project involve message broker patterns message_broker(IN json_in JSONB, OUT json_out JSONB), I find the Prologish style better.