Re: Is this proper UNION behavior?? - Mailing list pgsql-general

From Cristóvão B. B. Dalla Costa
Subject Re: Is this proper UNION behavior??
Date
Msg-id 005101c04e4e$e0ca8c00$02ffa8c0@terrificus
Whole thread Raw
In response to Is this proper UNION behavior??  ("Edward Q. Bridges" <ed.bridges@buzznik.com>)
Responses Re: Is this proper UNION behavior??  (Jules Bean <jules@jellybean.co.uk>)
List pgsql-general
> Of course, the real bug here is in SQL, namely that it allows
> duplicates in tables.

Or maybe not. Tables are not *always* relations, one may have a table of
things to do. If one thing has to be done twice, it might have two entries
on the table.

It all depends on the workings of the programs using the database. Just
imagine you SELECT a subset of a tables's unique rows, but that subset
doesn't produce unique rows. Should the non-unique ones be removed behind
your back? I think not.




pgsql-general by date:

Previous
From: Igor Roboul
Date:
Subject: Re: GT.M database open sourced
Next
From: "Adam Lang"
Date:
Subject: XML