Re: Probs "compiling" a function

On Tuesday 08 Oct 2002 3:14 am, gordoncl@optusnet.com.au 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