Re: ERROR: missing FROM-clause entry for table on postgresql 8.1 not on 7.4; deleting from a join

m laks wrote:
> --- On *Tue, 6/17/08, Tommy Gildseth /<tommy(dot)gildseth(at)usit(dot)uio(dot)no>/* wrote:
>
> F
>
>
>
> How about something along these lines:
>
>
> delete from instancetable
> USING imagelevel
> WHERE (
> (imagelevel.serparent= '1.2.840.113704.1.111.4640.1185891989.4') and
> (instancetable.imageuid= imagelevel.sopinsuid)
> )
>
> Thank You so much!! It works perfectly!!!!!
>
> 1. Where is this documented, and
> 2. where can I read more about what changed
> between the 7 series and 8 series that caused this?
>
> Thank you so much!!!!!!!!!
> Mitchell
>
>

As usual, the fine manual :-)
http://www.postgresql.org/docs/8.1/interactive/sql-delete.html

--
Tommy Gildseth