Re: syntax error in function - Mailing list pgsql-novice

From Keith Worthington
Subject Re: syntax error in function
Date
Msg-id 20041221180521.M87099@narrowpathinc.com
Whole thread Raw
In response to Re: syntax error in function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
> "Keith Worthington" <keithw@narrowpathinc.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


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: syntax error in function
Next
From: "Vishal Kashyap @ [SaiHertz]"
Date:
Subject: Re: SQUID Log in PostgreSQL