Re: UNION discards indentical rows in postgres 7.3.3

Hi Stephan,

Thanks a lot for the answer.

On Thu, 7 Aug 2003 15:10:00 -0700 (PDT), you wrote:

>> instead of the required one.
>
>That is the required resultset.  Union is required to do return only
>one copy of a row when there are duplicates of a row. Union all returns
>a number of copies equal to the number of duplicates.

Right ! i forgot that :-) (blushing).
Sorry.


Thank you again,

Silvio Scarpati