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
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2006-05-12 00:14:54|
|Subject: Re: BUG #2428: ERROR: out of memory, running INSERT SELECT statement |
|Previous:||From: Tom Lane||Date: 2006-05-11 19:33:36|
|Subject: Re: SIGSEGV happens over once a day |