Re: Error near delete in plpgsql function

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: Error near delete in plpgsql function
Дата
Msg-id 201106060915.30406.ahodgson@simkin.ca
обсуждение исходный текст
Ответ на Error near delete in plpgsql function  (Saqib Ilyas <msaqib@gmail.com>)
Список pgsql-novice
On June 6, 2011 08:58:49 AM Saqib Ilyas wrote:
>         END LOOP

> ERROR:  syntax error at or near "delete"
> CONTEXT:  compile of PL/pgSQL function "delete_items" near line 9
> ERROR:  syntax error at or near "delete"
> CONTEXT:  compile of PL/pgSQL function "delete_items" near line 9
>
> Any idea why this happened? I've tried searching the web and the archives,
> but no clue.
> Thanks and best regards

missing semi-colon at end of line 9 (the first END LOOP).


--
Obama has now fired more cruise missiles than all other Nobel Peace prize
winners combined.

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

Предыдущее
От: Saqib Ilyas
Дата:
Сообщение: Error near delete in plpgsql function
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Error near delete in plpgsql function