From: | Emmanuel Charpentier <charpent(at)bacbuc(dot)dyndns(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Delete and self-join |
Date: | 2001-01-19 21:55:39 |
Message-ID: | 3A68B7DB.2C69B5C@bacbuc.dyndns.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Nick Worth wrote:
>
> Hi,
>
> I have recently started porting some stuff from Oracle to PostgreSQL, and am
> having trouble with the following construct from Oracle:
>
> DELETE FROM serviceproviders sp1
> WHERE exists (SELECT 1
> FROM serviceproviders sp2 where
> sp1.class = sp2.class
> AND sp1.userid = sp2.userid
> AND sp1.providerclass = oldproviderclass
> AND sp1.providerid = newproviderid
> AND sp2.providerclass = oldproviderclass
> AND sp2.providerid = oldproviderid);
>
> PostgreSQL returns the following error when trying to execute the aqbove
> code in a stored procedure:
>
> ERROR: parser: parse error at or near "sp1"
>
> I have tried a number of options, but PostgreSQL doesn't seem to like sp1 in
> the DELETE clause, and if I don't have that then short of writing some code
> to select and delete in a loop I don't see how to achieve the same effect.
>
> As I am new to postgres I may be missing something obvious.
> Any help would be much appreciated.
[ Donning dumb hat ... ]
Did you try :
DELETE FROM serviceproviders AS sp1
?
[ Leaving dumb hat ]
[ Donning dumber hat ]
Did you try using another name ?
[ Leaving dumber hat ]
[ Donning asbestos longjohns ]
Hope this helps !
Emmanuel Charpentier
--
Emmanuel Charpentier
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Wood | 2001-01-19 22:02:43 | Re: Re: couple of general questions |
Previous Message | Stephan Szabo | 2001-01-19 21:32:34 | Re: Delete and self-join |