Keith Wong <keith@e-magine.com.au> writes:
> It seems that pl/pgsql has a problem parsing Window style
> new line characters.
Ah-hah, good catch! I have fixed this bug for 7.1. If you want to
patch your local copy, the critical changes are:
*** src/pl/plpgsql/src/scan.l.orig Thu Jun 22 19:08:34 2000
--- src/pl/plpgsql/src/scan.l Tue Aug 22 10:59:28 2000
***************
*** 143,155 **** * Ignore whitespaces but remember this happened * ---------- */
! [ \t\n]+ { plpgsql_SpaceScanned = 1; } /* ---------- * Eat up comments * ----------
*/
! --[^\n]* ; \/\* { start_lineno = yylineno; BEGIN IN_COMMENT; }
--- 146,158 ---- * Ignore whitespaces but remember this happened * ---------- */
! [ \t\r\n]+ { plpgsql_SpaceScanned = 1; } /* ---------- * Eat up comments * ----------
*/
! --[^\r\n]* ; \/\* { start_lineno = yylineno; BEGIN IN_COMMENT; }
regards, tom lane