From: | Dario Basso Cardoso <cardosodario(at)itelefonica(dot)com(dot)br> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: possible bug in SELECT with UNION |
Date: | 2006-05-12 14:40:28 |
Message-ID: | 44649E5C.2010902@itelefonica.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Thank you
With UNION ALL the SQL work correct for my case...
Dario.
Tom Lane escreveu:
>Dario Basso Cardoso <cardosodario(at)itelefonica(dot)com(dot)br> writes:
>
>
>>I receive two (2) rows if i union with other table i receive one (1) row!!!
>>
>>
>
>You do know that UNION is defined to eliminate duplicate output rows?
>(UNION ALL doesn't eliminate duplicates, and might be what you want.)
>
>If that's not what you're seeing then you need to provide more info.
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Douglas Toltzman | 2006-05-12 15:03:36 | Re: backup database by pg_dump |
Previous Message | Tom Lane | 2006-05-12 14:25:35 | Re: BUG #2435: pg_dump/pg_restore with tar format misses indices and constraints |