Re: Error near delete in plpgsql function

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Error near delete in plpgsql function
Date: 2011-06-06 16:15:30
Message-ID: 201106060915.30406.ahodgson@simkin.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2011-06-06 16:16:54 Re: Error near delete in plpgsql function
Previous Message Saqib Ilyas 2011-06-06 15:58:49 Error near delete in plpgsql function