Re: problem with NOTICE: _outNode: don't know how to print type

Joseph S <jks@selectacast.net>

From: Joseph Shraibman <jks@selectacast.net>
To: Martijn van Oosterhout <kleptog@cupid.suninternet.com>
Cc: Ari Jolma <ajolma@water.hut.fi>, pgsql-general@postgresql.org
Date: 2000-05-25T21:05:48Z
Lists: pgsql-general
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)