Hi folks.
I have two selects which in themselves report what they should. However, when
I run a union to combine their outputs (to then feed a select/count) lines
disappear. Below are the two seperate selects, followed by the untion in
which duplicate rows are lost. I'm using Postgresql 8.3.3-
Documented behavior. Please read the section on UNION for the why and the
proper alternative syntax:
http://www.postgresql.org/docs/9.0/interactive/sql-select.html
On Mar 28, 2012, at 7:01, Gary Stainburn wrote:
> Hi folks.
>
> I have two selects which in themselves report what they should.
Thanks for this David.
Does anyone know why it too until Saturday for my post to appear on the listr?
Gary
On Saturday 31 March 2012 02:19:50 David Johnston wrote:
> Documented behavior. Please read the section on UNION for the why and the
> proper alternative syntax:
>
> http://www.postgresql
On 2012-04-02, Gary Stainburn wrote:
> Thanks for this David.
>
> Does anyone know why it too until Saturday for my post to appear on the listr?
>
> Gary
If you haven't signed up for the mailing list with exactly the same email
address that you post from the message will be held for moderation.