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)