PostgreSQL PL pgSQL — reference sample — DedSec Project

CREATE OR REPLACE FUNCTION greet(name text) RETURNS text LANGUAGE plpgsql AS $ BEGIN RETURN 'Hello, ' name '!'; END; $; SELECT greet('Ada');

Source reference

CREATE OR REPLACE FUNCTION greet(name text)
RETURNS text LANGUAGE plpgsql AS $
BEGIN
  RETURN 'Hello, ' || name || '!';
END; $;
SELECT greet('Ada');