Postgres Pro
Downloads
Home   >   mailing lists

Thread: AW: Re: Query 'Bout A Bug.

AW: Re: Query 'Bout A Bug.

From
Zeugswetter Andreas SB
Date:
> > The bug list includes the following:
> >  
> > a.. SELECT foo UNION SELECT foo is incorrectly simplified 
> to SELECT foo 
> > 
> > Wy is this simplification incorrect? I don't get it.
> 
> Not sure.  Maybe someone can comment. 

It can only be simplified to:SELECT DISTINCT * from foo

Andreas