On Tue, 27 May 2003, Jim C. Nasby wrote:
> I'm getting this error trying to run a function:
>
> usps=# select process_zip4();
> WARNING: Error occurred while executing PL/pgSQL function process_zip4
> WARNING: line 55 at SQL statement
> ERROR: parser: parse error at or near "$1" at character 14
>
> The relivant code is:
>
> IF z.record_type_code = ''P'' THEN
> INSERT INTO po_box
> SELECT z4.zip4_id
> , ....
>
> The INSERT INTO is line 55. What makes no sense is that it works fine if
> I change the name of the table from po_box to anything else.
Do you happen to have a declared variable named po_box? IIRC
plpgsql gets confused sometimes when things like that are done.