From: | "Jim C(dot) Nasby" <jim(at)nasby(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Bizzare plpgsql error |
Date: | 2003-05-27 19:56:00 |
Message-ID: | 20030527195600.GT40542@flake.decibel.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
Any ideas?
--
Jim C. Nasby (aka Decibel!) jim(at)nasby(dot)net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2003-05-27 20:08:12 | Re: Postgresql on SUN Server |
Previous Message | Alvaro Herrera | 2003-05-27 19:48:07 | Re: newbie sql question... |