From: Richard Jones <r.d.jones@ed.ac.uk>
To: Viorel Dragomir <bc@vio.ro>
To: pgsql-sql@postgresql.org
To: terry@ashtonwoodshomes.com
To: dmitry@openratings.com
Subject: Re: NOT and AND problem
Date: Thu, 17 Jul 2003 16:09:45 +0100
Message-ID: <00db01c34c75$754a6400$5192d781@lib.ed.ac.uk> (raw)
References: <BB3C6BB2.20059%awitney@sghms.ac.uk>
<009f01c34c6f$ca98d3c0$5192d781@lib.ed.ac.uk>
<01d401c34c70$97983a50$0600a8c0@fix.ro>
Hello,
Just to say thanks for such fast responses. The full working query is
indeed as suggested (I cut the demo query down when I posted it, as it's got
some awfully long names in it in real life):
DELETE FROM eulepersongroup2workspaceitem
WHERE NOT EXISTS (
SELECT 1 FROM workspaceitem WHERE workspace_item_id =
eulepersongroup2workspaceitem.workspace_item_id
) OR NOT EXISTS (
SELECT 1 FROM epersongroup WHERE eperson_group_id =
eulepersongroup2workspaceitem.eperson_group_id
);
Thanks very much for your help.
Regards
Richard
Richard Jones
-----------------------
Systems Developer
Theses Alive! - www.thesesalive.ac.uk
Edinburgh University Library
r.d.jones@ed.ac.uk
0131 651 1611
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: r.d.jones@ed.ac.uk, bc@vio.ro, terry@ashtonwoodshomes.com, dmitry@openratings.com
Subject: Re: NOT and AND problem
In-Reply-To: <00db01c34c75$754a6400$5192d781@lib.ed.ac.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox