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
Ответ на
Список
Дерево обсуждения
Problem with dollar-quoted CREATE OR REPLACE FUNCTION Tim Penhey <tim@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 Tim Penhey <tim@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 Kris Jurka <books@ejurka.com>
Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION Oliver Jowett <oliver@opencloud.com>
Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION Kris Jurka <books@ejurka.com>
Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION Oliver Jowett <oliver@opencloud.com>
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
Дата:
От: Dave Cramer
Дата:
FAQ