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

[Tommy Gildseth]

m laks wrote:

--- On *Tue, 6/17/08, Tommy Gildseth /<[EMAIL PROTECTED]>/* 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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general