[SQL] 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
[SQL] 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 Edurado B. L. e Carvalho Development/Consultant
