Re: Error near delete in plpgsql function - Mailing list pgsql-novice

From Alan Hodgson
Subject Re: Error near delete in plpgsql function
Date
Msg-id 201106060915.30406.ahodgson@simkin.ca
Whole thread Raw
In response to Error near delete in plpgsql function  (Saqib Ilyas <msaqib@gmail.com>)
List 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 by date:

Previous
From: Saqib Ilyas
Date:
Subject: Error near delete in plpgsql function
Next
From: Tom Lane
Date:
Subject: Re: Error near delete in plpgsql function