Trigger problem - Mailing list pgsql-admin

From jquest jquest
Subject Trigger problem
Date
Msg-id F1865G5skRBzRsx6Eyj00009c24@hotmail.com
Whole thread Raw
Responses Re: Trigger problem  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: Trigger problem  (Aaron Spiteri <aaron@m1group.com.au>)
List 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


pgsql-admin by date:

Previous
From: Aaron Spiteri
Date:
Subject: Fast CGI
Next
From: Stephan Szabo
Date:
Subject: Re: Trigger problem