Received: from mail1.forsingles.com (unknown [216.52.172.68])
	by postgresql.org (Postfix) with ESMTP id 7DB8B475BE1
	for <pgsql-sql@postgresql.org>; Thu, 25 Jul 2002 13:19:30 -0400 (EDT)
Received: from yudie (216.52.172.78 [216.52.172.78]) by mail1.forsingles.com
	with SMTP (Microsoft Exchange Internet Mail Service Version
	5.5.2653.13) id PGF2N1CS; Thu, 25 Jul 2002 12:19:36 -0500
Message-ID: <00bc01c233ff$8d5489c0$8a01a8c0@yudie>
From: "Yudie@axiontech.com" <yudie@axiontech.com>
To: <pgsql-sql@postgresql.org>
Subject: problem with plpgsql trigger function: parse error near ""
Date: Thu, 25 Jul 2002 12:20:13 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
X-Archive-Number: 200207/405
X-Sequence-Number: 8783

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();