Re: possible bug in SELECT with UNION

Thank you

With UNION ALL the SQL work correct for my case...

Dario.

Tom Lane escreveu:

>Dario Basso Cardoso <cardosodario@itelefonica.com.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@postgresql.org so that your
>       message can get through to the mailing list cleanly
>
>
>
>