| 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
| 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 ? |