Re: select union with table name - Mailing list pgsql-general

From Alban Hertroys
Subject Re: select union with table name
Date
Msg-id 459A2844.4020206@magproductions.nl
Whole thread Raw
In response to Re: select union with table name  (Reece Hart <reece@harts.net>)
List pgsql-general
Reece Hart wrote:
> On Thu, 2006-12-28 at 19:09 +0700, Akbar wrote:
> Note the 'all' after union... I suspect you'll want that or should at
> least consider it.

Not using it will give the exact same results in a slower way; 'blue'
and 'red' are different, after all. You'll be hard pressed to find a
good excuse for not using UNION ALL here ;)

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
   7500 AK Enschede

// Integrate Your World //

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Application validation of data on insert
Next
From: Richard Huxton
Date:
Subject: Re: Why ContinueUpdateOnError is not implemented in npgsql