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!