On Wed, Oct 20, 2004 at 01:54:04PM +0200, Sim Zacks wrote: > It is very weird, I just tried both a group by and distinct and both > of them still return the duplicates. > > I also tried a very simple union which didn't return any duplicates, > both of these said, it is obviously not a problem with union.
Not related to your underlying problem, but be aware that UNION does eliminate duplicates by design, so that could explain what you are seeing here. If you don't want it to do that, use UNION ALL instead (the same applies to INTERSECT and EXCEPT if you ever happen to use them). -- Alvaro Herrera (<[EMAIL PROTECTED]>) "Saca el libro que tu religi�n considere como el indicado para encontrar la oraci�n que traiga paz a tu alma. Luego rebootea el computador y ve si funciona" (Carlos Ducl�s) ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
