In postgres you the plsql equivalent is 'plpgsql' not 'plsql'.
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 3/05/02, 21:17:38, "jquest jquest" <jquest_j@hotmail.com> wrote
regarding [ADMIN] Trigger problem:
> Hi,
> I am new to postgresql and to this moment I am using oracle.
> I use posgresql 7.1.2
> I try to create very simple ( from doc. examples ) trigger:
> CREATE FUNCTION add_one (integer) RETURNS INTEGER AS '
> BEGIN
> RETURN $1 + 1;
> END;
> ' LANGUAGE 'pgsql';
> But the system report:
> ERROR: Unrecognized language specified in a CREATE FUNCTION: 'pgsql'.
> Recognized languages are sql, C, internal, and created procedural
> languages.
> I readet in documentation that pgsql is good solution for SP.
> Where is the problem?
> Many thanks in advance.
> _________________________________________________________________
> Send and receive Hotmail on your mobile device: http://mobile.msn.com
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)