In postgres you the plsql equivalent is 'plpgsql' not 'plsql'. >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 3/05/02, 21:17:38, "jquest jquest" <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
