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

From: m laks <mlaks2000(at)yahoo(dot)com>
To: Tommy Gildseth <tommy(dot)gildseth(at)usit(dot)uio(dot)no>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: missing FROM-clause entry for table on postgresql 8.1 not on 7.4; deleting from a join
Date: 2008-06-17 12:03:07
Message-ID: 305478.10444.qm@web33611.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--- On Tue, 6/17/08, Tommy Gildseth &lt;tommy(dot)gildseth(at)usit(dot)uio(dot)no&gt; 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2008-06-17 12:09:50 Re: problem with to_ascii() function in version 8.3.3
Previous Message Albe Laurenz 2008-06-17 12:01:23 Re: Error when trying to drop a tablespace