Re: [HACKERS] Oops, I seem to have changed UNION's behavior

> > Am I right in thinking that UNION (without ALL) is defined to do a
> > DISTINCT on its result, so that duplicates are removed even if the
> > duplicates both came from the same source table?  That's what 6.4.2
> > does, but I do not know if it's strictly kosher according to the SQL
> > spec.

(Just in case this is still active)

Yes, this is the right behavior according to SQL92...
                        - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California