Re: Trigger problem

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)