Manfred Koizar wrote: > On Tue, 19 Jul 2005 11:51:51 +0100, Richard Huxton <dev@archonet.com> > wrote: > >>You could get away with one query if you converted them to left-joins: >>INSERT INTO ... >>SELECT * FROM upload LEFT JOIN ... WHERE f3 IS NULL >>UNION >>SELECT * FROM upload LEFT JOIN ... WHERE f4 IS NULL > > > For the archives: This won't work. Each of the two SELECTs > eliminates rows violating one of the two constraints but includes rows > violating the other constraint. After the UNION you are back to > violating both constraints :-(
Couldn't you use "INTERSECT" then? To only get the rows that *both* queries return? John =:-> > > Servus > Manfred > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings >
signature.asc
Description: OpenPGP digital signature
