Re: UNION discards indentical rows in postgres 7.3.3

From: Silvio Scarpati <silvio(dot)scarpati(at)virgilio(dot)it>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: UNION discards indentical rows in postgres 7.3.3
Date: 2003-08-08 19:12:14
Message-ID: F=UzPzhZgzNnEATr9UBQQ2i0WgGf@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-08-08 19:56:27 Re: vacuum is not sufficient?
Previous Message Bruce Momjian 2003-08-08 17:18:08 Re: upcoming 7.4 relaese: absent recode() function ?