Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION - Mailing list pgsql-jdbc

From Tim Penhey
Subject Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION
Date
Msg-id 4147067C.6070008@penhey.net
Whole thread Raw
In response to Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION
List pgsql-jdbc
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


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION
Next
From: Dave Cramer
Date:
Subject: Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION