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