Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Tom LaneDate: 2011-06-06 16:16:54
Subject: Re: Error near delete in plpgsql function
Previous:From: Saqib IlyasDate: 2011-06-06 15:58:49
Subject: Error near delete in plpgsql function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group