pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Lu Raymond <raymond_lu99@hotmail.com>
To: pgsql-docs@postgresql.org
Cc: raymond_lu99@hotmail.com
Subject: There is error at the examples in PL/pgSQL
Date: Mon, 05 Mar 2001 01:52:08 -0000
Message-ID: <F294wLJGStz2wOoalD500009487@hotmail.com> (raw)

Hello,all

I use your a example of PL/pgSQL, but I found some errors when I execute 
these codes. The details are followings,

First, I create a exam.sql that includes these codes as followings,

CREATE TABLE emp (
    empname text,
    salary int4,
    last_date datetime,
    last_user name);

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 := getpgusername();
        RETURN NEW;
    END;
' LANGUAGE 'plpgsql';

CREATE TRIGGER emp_stamp BEFORE INSERT OR UPDATE ON emp
    FOR EACH ROW EXECUTE PROCEDURE emp_stamp();



Secondly, I execute exam.sql and the postgress can create the table emp,
the function emp_stamp() and the trigger emp_stamp seccessfully.But when I 
insert one record to table emp, there are some errors on the screen.
   the insert statement is followings,
      INSERT INTO emp Values('','','20001220','raymond');

the error of screen is:
NOTICE: plpgsql: ERROR during compile of emp_stamp near line 1
"RROR: parse error at or near "

Why? and what wrong is it? Please give me reply as possible as you can. 
Thanks!






_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.




view thread (2+ messages)  latest in thread

Message-ID: <F294wLJGStz2wOoalD500009487@hotmail.com>
Permalink:  ../F294wLJGStz2wOoalD500009487@hotmail.com/
Also on:    postgresql.org/message-id/F294wLJGStz2wOoalD500009487@hotmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-docs@postgresql.org
  Cc: raymond_lu99@hotmail.com
  Subject: Re: There is error at the examples in PL/pgSQL
  In-Reply-To: <F294wLJGStz2wOoalD500009487@hotmail.com>
  References: <F294wLJGStz2wOoalD500009487@hotmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox