| From: | "Keith Worthington" <keithw(at)narrowpathinc(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "PostgreSQL Novice" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: syntax error in function |
| Date: | 2004-12-21 18:05:21 |
| Message-ID: | 20041221180521.M87099@narrowpathinc.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
> "Keith Worthington" <keithw(at)narrowpathinc(dot)com> writes:
> > I am afraid I cannot see the
> > forest through the trees. Can someone point out the error of my ways?
>
> I think you're missing a semicolon at the end of the PERFORM.
>
> plpgsql's syntax error reporting kinda sucks :-(. There are some
> proposals afoot to improve it in 8.1 ...
>
> regards, tom lane
Thanks Tom.
As it turns out I was missing two semicolons and had three extra commas and
two underspecified values. Sheesh!
Kind Regards,
Keith
______________________________________________
99main Internet Services http://www.99main.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vishal Kashyap @ [SaiHertz] | 2004-12-21 18:41:46 | Re: SQUID Log in PostgreSQL |
| Previous Message | Tom Lane | 2004-12-21 17:47:10 | Re: syntax error in function |