Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION

Tim,

Ideally you should look in the logs, I suspect that if you escaped the $
with \$ it should work.

Dave
On Tue, 2004-09-14 at 10:55, Tim Penhey wrote:
> Dave Cramer wrote:
>
> >Can you show us the code, logs?
> >
> >Dave
> >
> >
>
> CREATE OR REPLACE FUNCTION quote_test(first INTEGER, second INTEGER)
>     RETURNS INTEGER AS $BODY$
> DECLARE
>     result INTEGER;
> BEGIN
>     result := first + second;
>     RETURN result;
> END;
> $BODY$
> LANGUAGE 'plpgsql';
>
>
> This gives the error in eclipse.  Didn't mention before but using
> MyEclipseIDE plugin for DB access in Eclipse.
>
> Also, just noticed the jdbc directory with the 8.0 beta.  Should I be
> using that instead of the pgdev one?
> It has pg74.214.jdbc1.jar, pg74.214.jdbc2.jar, pg74.214.jdbc2ee.jar,
> pg74.214.jdbc3.jar.  Would these be better?
>
> Tim
>
--
Dave Cramer
519 939 0336
ICQ # 14675561
www.postgresintl.com