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