Hi, Mark, [EMAIL PROTECTED] schrieb:
> I ran into something I wasn't expecting while developing a new > application. I have two similar tables that are occasionally unioned > pulling only about 3 fields from each. During my testing phase I > noticed that the union statement was returning what appeared to be a > distinct list rather than a pure union such as is illustrated below: This is the documented behaviour of UNION, if you don't wand duplicate elimination, use UNION ALL. http://www.postgresql.org/docs/8.1/static/sql-select.html documents this nicely. HTH, Schabi ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
