[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-sql
Subject: Re: [SQL] Question on UNION
From: Markus Schaber <schabi () logix-tt ! com>
Date: 2006-05-22 19:07:34
Message-ID: 44720BF6.6050109 () logix-tt ! com
[Download RAW message or body]
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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic