| 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: | Whole Thread | Raw Message | 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
| 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 |