Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION

Поиск
Список
Период
Сортировка
От Tim Penhey
Тема Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION
Дата
Msg-id 4147067C.6070008@penhey.net
обсуждение исходный текст
Ответ на Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION  (Dave Cramer <pg@fastcrypt.com>)
Ответы Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION  (Dave Cramer <pg@fastcrypt.com>)
Список 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 по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION