PostgreSQL SQL - Re: Tracking Down Error in Stored Procedure

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Tracking Down Error in Stored Procedure

Aaron Bono

2006-12-02, 5:15 am

On 12/2/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> "Aaron Bono" <postgresql@aranya.com> writes:
> execute
>
>
> It's the 200th line in the function body string. IIRC there is a
> special case to not count a leading newline in the body string,
> so that the counting goes like
>
> CREATE FUNCTION foo ...
> RETURNS ...
> AS $$
> DECLARE -- this is line 1
>
> or without exploiting the special case
>
> CREATE FUNCTION foo ...
> RETURNS ...
> AS $$DECLARE -- this is line 1
>
> regards, tom lane
>

I got it fixed. Thanks for the help!

--
====================
====================
====================
======
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
====================
====================
====================
======

Sponsored Links