On Fri, 26 May 2000, 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. As the message suggests, a is not a
> printable type. Maybe you meant a.* ?
The SQL statement above is just for showing what kind
of statement causes the problem. I originally noticed the
problem when I gave \l and then did a little research and
found out that actually \l is implemented as something
resembling what I wrote above. I was just trying to write
the simplest SQL statement I could to generate the problem.
It seems that there needs to be a union and a subselect.
And the really curious thing is that this problem seems
to depend on which redhat version there is!
Ari Jolma
