You probably copied it from a machine that uses CR/LF rather than LF as
newline.  I think 7.1 handles this but earlier ones will fail.  Trim
the CR characters and it should work.

On Mon, 5 Mar 2001, Lu Raymond wrote:


> 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!


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to