plpgsql

consultas=# CREATE FUNCTION spread(text)
consultas-# RETURNS text
consultas-# AS 'DECLARE
consultas'# str text;
consultas'# ret text;
consultas'# i integer;
consultas'# len integer;
consultas'# BEGIN
consultas'# str := upper($1);
consultas'# ret := ''''; -- start with zero length
consultas'# i := 1;
consultas'# len := length(str);
consultas'# WHILE i <= len LOOP
consultas'# ret := ret || substr(str, i, 1) || '' '';
consultas'# i := i + 1;
consultas'# END LOOP;
consultas'# RETURN ret;
consultas'# END;'
consultas-# LANGUAGE 'plpgsql';
ERROR: Unrecognized language specified in a CREATE
FUNCTION: 'plpgsql'. Recognized languages are sql, C, internal and the
created procedural languages.

consultas=# select version();
version
-------------------------------------------------------------
PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.96
(1 row)

--

Fernando Eduardo B. L. e Carvalho
Development/Consultant