Received: from rmx325-mta.mail.com (rmx325-mta.mail.com [165.251.48.53]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA11226 for ; Tue, 30 May 2000 12:36:36 -0400 (EDT) (envelope-from p.lam@altavista.net) From: p.lam@altavista.net Received: from weba1.iname.net (weba1.iname.net [165.251.4.11]) by rmx325-mta.mail.com (8.9.3/8.9.3) with ESMTP id MAA12079 for ; Tue, 30 May 2000 12:36:35 -0400 (EDT) Received: (from root@localhost) by weba1.iname.net (8.9.1a/8.9.2.Alpha2) id MAA25927; Tue, 30 May 2000 12:36:34 -0400 (EDT) MIME-Version: 1.0 Message-Id: <000530123634BP.00589@weba1.iname.net> Date: Tue, 30 May 2000 12:36:34 -0400 (EDT) Content-Type: Text/Plain Content-Transfer-Encoding: 7bit To: pgsql-sql@postgresql.org Subject: Pg/PLSQL Errors!! X-Archive-Number: 200005/201 I am running PostgreSQL 6.5.3 on RedHat Linux 6.1 on a PC. I am trying to use Pg/PLSQL. I even tried being conservative enough to copy the example code from http://www.postgresql.org/docs/user/c40874340.htm as follows: CREATE FUNCTION add_one (int4) RETURNS int4 AS ' BEGIN RETURN $1 + 1; END; ' LANGUAGE 'plpgsql'; though, even that results in "ERROR: Unrecognized language specified in a CREATE FUNCTION: 'pl-pgsql'. Recognized languages are sql, C, internal and the created procedural languages." I have tried variants including PLSQL,PG/PLSQL,PL/SQL,PGSQL and even 'internal procedural language(s)' and 'created procedural language(s)' though with the same error. Does anyone know of the name of the postgreSQL's procedural language of form like CREATE function funcName(arguments) returns returntype AS 'BEGIN statement block END;' LANGUAGE '??????'; Many Thanks! ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com