On 12/15/06, Ragnar <[EMAIL PROTECTED]> wrote:
On fös, 2006-12-15 at 16:17 -0600, Aaron Bono wrote:
> On 12/15/06, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Aaron Bono" <[EMAIL PROTECTED]> writes:
> > My question, what do the SQL Specifications say should
> happen on a Union
On fös, 2006-12-15 at 16:17 -0600, Aaron Bono wrote:
> On 12/15/06, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Aaron Bono" <[EMAIL PROTECTED]> writes:
> > My question, what do the SQL Specifications say should
> happen on a Union?
> > Is it supposed to eliminate duplicat
On 12/15/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Aaron Bono" <[EMAIL PROTECTED]> writes:
> My question, what do the SQL Specifications say should happen on a
Union?
> Is it supposed to eliminate duplicates even WITHIN the individual
queries
> that are being unioned?
Yes. SQL92 7.10 saith:
"Aaron Bono" <[EMAIL PROTECTED]> writes:
> My question, what do the SQL Specifications say should happen on a Union?
> Is it supposed to eliminate duplicates even WITHIN the individual queries
> that are being unioned?
Yes. SQL92 7.10 saith:
b) If a set operator is specified, then th
I have a question about the SQL Specifications in regards to Unions...
I recently put together a query that involved unions similar to the
following:
SELECT
'Query 1' as id,
my_value
FROM my_view
UNION
SELECT
'Query 2' as id,
my_value
FROM my_other_view
;
The first query in the unio
