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(at)hotmail(dot)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(at)postgresql(dot)org)