Martijn van Oosterhout wrote:
>
> Ari Jolma wrote:
> > template1=> select a from a union select a from a where a in (select a from
> > a);
> > NOTICE: _outNode: don't know how to print type 1044119613
> > NOTICE: _outNode: don't know how to print type 1044119613
> > a
> > -
> > (0 rows)
>
> Hmm, I may be missing something, but "select a from a" is not
> a legal statement.
Why not?
playpen=> create table a ( a int ) ;
CREATE
playpen=> insert into a values(1);
INSERT 28310 1
playpen=> insert into a values(2);
INSERT 28311 1
playpen=> select a from a union select a from a where a in (select a
from a);
a
-
1
2
(2 rows)
