Re: There is error at the examples in PL/pgSQL

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!