Re: missing... at end of sql expression

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: missing... at end of sql expression
Дата
Msg-id 1449.1101085413@sss.pgh.pa.us
обсуждение исходный текст
Ответ на missing... at end of sql expression  (Justine.Cleary@c1data.com)
Список pgsql-sql
Justine.Cleary@c1data.com writes:
> I am trying to learn pspgsql but I am not having a lot of luck.
> I have written a function but I keep getting the error missing... at end of
> sql expression. Can anyone help!

What it's really unhappy about is that you failed to declare the FOR
variable; this is causing it to assume that the FOR is the integer
variant (FOR i IN low .. high).

The error message is pretty confusing, I agree.  I think 8.0 will
do better.
        regards, tom lane


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

Предыдущее
От: "Premsun Choltanwanich"
Дата:
Сообщение: How to make lo_import and lo_export to use file on client local machine?
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: missing... at end of sql expression