On Wed, 23 Jan 2002, Ben-Nes Michael wrote:
> comp.canaan.co.il=# CREATE FUNCTION addnumbers (INTEGER, INTEGER) RETURNS
> INTEGER AS '
> comp.canaan.co.il'# DECLARE
> comp.canaan.co.il'# v1 ALIAS FOR $1;
> comp.canaan.co.il'# v2 ALIAS FOR $2;
> comp.canaan.co.il'# BEGIN
> comp.canaan.co.il'# RETURN v1 + v2;
> comp.canaan.co.il'# END;'
> comp.canaan.co.il-# LANGUAGE 'plpgpsql';
You meant 'plpgsql' right? ;)
> ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgpsql'.
> Recognized languages are sql, C, internal, and created procedural
> languages.