Re: Question on UNION

Hi, Mark,

mark.dingee@cox.net 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