Skip site navigation (1) Skip section navigation (2)

Re: possible bug in SELECT with UNION

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 (view raw or flat)
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
>
>
>  
>


In response to

pgsql-bugs by date

Next:From: Douglas ToltzmanDate: 2006-05-12 15:03:36
Subject: Re: backup database by pg_dump
Previous:From: Tom LaneDate: 2006-05-12 14:25:35
Subject: Re: BUG #2435: pg_dump/pg_restore with tar format misses indices and constraints

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group