Peter M. Groen / knowledgetree

functions.sql 189 Bytes
1 2 3 4 5 6 7 8 9 10 11 
CREATE FUNCTION concat (text, text)
RETURNS text
AS '
    select $1 || $2'
LANGUAGE sql;

CREATE FUNCTION left (text, integer)
RETURNS text
AS '
    select substr($1, 1, $2)'
LANGUAGE sql;