Postgres Pro
Downloads
Home   >   mailing lists

Re: possible bug in SELECT with UNION - Mailing list pgsql-bugs

From Tom Lane
Subject Re: possible bug in SELECT with UNION
Date
Msg-id 3251.1147376845@sss.pgh.pa.us
Whole thread Raw
In response to possible bug in SELECT with UNION  (Dario Basso Cardoso <cardosodario@itelefonica.com.br>)
Responses Re: possible bug in SELECT with UNION  (Dario Basso Cardoso <cardosodario@itelefonica.com.br>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: SIGSEGV happens over once a day
Next
From: Tom Lane
Date:
Subject: Re: BUG #2428: ERROR: out of memory, running INSERT SELECT statement