[ADMIN] Help on Trugger/Function

[Pam Wampler]

I am new to postgresql -- I am trying to create a trigger on a table --
I get this error on the function  
   ERROR:  Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
Recognized languages are sql, C, internal, and created procedural
languages.

Here is my function that I get this error on:

create function head_insert() returns OPAQUE as '
   BEGIN
   NEW.tests := 0;
   NEW.fails  := 0;
   NEW.reps  := 0;
  END;
'
LANGUAGE 'plpgsql';



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster