problem with plpgsql trigger function: parse error near "" - Mailing list pgsql-sql

From Yudie@axiontech.com
Subject problem with plpgsql trigger function: parse error near ""
Date
Msg-id 00bc01c233ff$8d5489c0$8a01a8c0@yudie
Whole thread Raw
Responses Re: problem with plpgsql trigger function: parse error near ""
List pgsql-sql
I just tried the trigger function from:
http://developer.postgresql.org/docs/postgres/plpgsql-trigger.html
(You can read the sql command on the bottom of this message.)

When inserting into emp table i got error: --> parse error near ""

I just wondering if any of you have the same probelem;
The plpgsql language was just created with createlang plqpsql [dbname]

Thank you
Yudie

Sample Code:
CREATE TABLE emp (       empname text,       salary integer,       last_date timestamp,       last_user text   );
   CREATE FUNCTION emp_stamp () RETURNS OPAQUE AS '       BEGIN           -- Check that empname and salary are given
      IF NEW.empname ISNULL THEN               RAISE EXCEPTION ''empname cannot be NULL value'';           END IF;
    IF NEW.salary ISNULL THEN               RAISE EXCEPTION ''% cannot have NULL salary'', NEW.empname;           END
IF;
           -- Who works for us when she must pay for?           IF NEW.salary < 0 THEN               RAISE EXCEPTION
''%cannot have a negative salary'',
 
NEW.empname;           END IF;
           -- Remember who changed the payroll when           NEW.last_date := ''now'';           NEW.last_user :=
current_user;          RETURN NEW;       END;   ' LANGUAGE 'plpgsql';
 
   CREATE TRIGGER emp_stamp BEFORE INSERT OR UPDATE ON emp       FOR EACH ROW EXECUTE PROCEDURE emp_stamp();



pgsql-sql by date:

Previous
From: "Nathan Suderman"
Date:
Subject: queries got slower using 7.1.3
Next
From: Bruno Wolff III
Date:
Subject: Re: Using Tables from another database.