Postgres Pro
Downloads
Home   >   mailing lists

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

From m laks
Subject Re: ERROR: missing FROM-clause entry for table on postgresql 8.1 not on 7.4; deleting from a join
Date
Msg-id 305478.10444.qm@web33611.mail.mud.yahoo.com
Whole thread Raw
In response to Re: ERROR: missing FROM-clause entry for table on postgresql 8.1 not on 7.4; deleting from a join  (Tommy Gildseth <tommy.gildseth@usit.uio.no>)
Responses Re: ERROR: missing FROM-clause entry for table on postgresql 8.1 not on 7.4; deleting from a join  (Tommy Gildseth <tommy.gildseth@usit.uio.no>)
Re: ERROR: missing FROM-clause entry for table on postgresql 8.1 not on 7.4; deleting from a join  ("Richard Broersma" <richard.broersma@gmail.com>)
List pgsql-general
Tree view
--- On Tue, 6/17/08, Tommy Gildseth <tommy.gildseth@usit.uio.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

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Error when trying to drop a tablespace
Next
From: m laks
Date:
Subject: Re: ERROR: missing FROM-clause entry for table on postgresql 8.1 not on 7.4; deleting from a join