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

[Tommy Gildseth <tommy.gildseth@xxxxxxxxxxx>]

m laks wrote:
> --- On *Tue, 6/17/08, Tommy Gildseth /<tommy.gildseth@xxxxxxxxxxx>/* 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