Re: syntax error during function call

Поиск
Список
Период
Сортировка
От Aycock, Jeff R.
Тема Re: syntax error during function call
Дата
Msg-id 65151B9A7C8C9C4284ABC85F0336DE5003972E1C@0015-its-exmb11.us.saic.com
обсуждение исходный текст
Ответ на Re: syntax error during function call  (Adrian Klaver <adrian.klaver@gmail.com>)
Ответы Re: syntax error during function call  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: syntax error during function call  (Adrian Klaver <adrian.klaver@gmail.com>)
Список pgsql-general
Thanks for the catch.

However, this did not fix the syntax error.

-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@gmail.com]
Sent: Wednesday, January 27, 2010 11:47 AM
To: Aycock, Jeff R.
Cc: Pavel Stehule; pgsql-general@postgresql.org
Subject: Re: [GENERAL] syntax error during function call

On 01/27/2010 08:41 AM, Aycock, Jeff R. wrote:
> Adrian,
>
> I tried that as well and got the same error result.
>
> Regards,
> Jeff Aycock
>
>

I went back to the original function and assuming no cut/paste errors
there is a ';' missing after the last END.

             END;

         RETURN NEXT r;

     END LOOP;

     RETURN;

END

$BODY$

LANGUAGE 'plpgsql' ;


--
Adrian Klaver
adrian.klaver@gmail.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: syntax error during function call
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: syntax error during function call