Trigger problem

From: "jquest jquest" <jquest_j(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Trigger problem
Date: 2002-05-03 11:17:38
Message-ID: F1865G5skRBzRsx6Eyj00009c24@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mark McEahern 2002-05-03 15:12:09 configure datatype name > 31?
Previous Message Aaron Spiteri 2002-05-02 23:02:23 Fast CGI