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

Re: possible bug in SELECT with UNION

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dario Basso Cardoso <cardosodario(at)itelefonica(dot)com(dot)br>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: possible bug in SELECT with UNION
Date: 2006-05-11 19:47:25
Message-ID: 3251.1147376845@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-05-12 00:14:54
Subject: Re: BUG #2428: ERROR: out of memory, running INSERT SELECT statement
Previous:From: Tom LaneDate: 2006-05-11 19:33:36
Subject: Re: SIGSEGV happens over once a day

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