Skip site navigation (1) Skip section navigation (2)

Pg/PLSQL Errors!!

From: p(dot)lam(at)altavista(dot)net
To: pgsql-sql(at)postgresql(dot)org
Subject: Pg/PLSQL Errors!!
Date: 2000-05-30 16:36:34
Message-ID: 000530123634BP.00589@weba1.iname.net (view raw or flat)
Thread:
Lists: pgsql-sql
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

Responses

pgsql-sql by date

Next:From: Karel ZakDate: 2000-05-30 16:37:37
Subject: Re: Pg/PLSQL Errors!!
Previous:From: mikeoDate: 2000-05-30 15:35:04
Subject: Re: [SQL] remove line type?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group