On Tuesday 08 Oct 2002 3:14 am, [EMAIL PROTECTED] wrote: > Greetings, Having probs just "compiling" this fn and it comes back with a > very stark error msg which is below. I'm using version 7.1.3 > > I run the script as: > \i procedures/zff > > and get the error msg: > psql:procedures/zff:51: ERROR: parser: parse error at or near "b" > > Line 51 is the line that starts LANGUAGE.... ... > VALUES(upper($1),$2,upper($3),upper($4),$5,$6,$7,$8,$9,upper($10),$11, > $12,$13,$14,/'B/',t_class_sun,$16); I think the 'B' here might be the problem - did you mean \'B\' or ''B''?
It probably doesn't spot it until the end of the definition when it hits another quote on the "language" line. - Richard Huxton ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])