From: | Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com> |
---|---|
To: | Joseph Shraibman <jks(at)selectacast(dot)net> |
Cc: | Ari Jolma <ajolma(at)water(dot)hut(dot)fi>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: problem with NOTICE: _outNode: don't know how to print type |
Date: | 2000-05-26 12:55:42 |
Message-ID: | 392E744E.612B1B09@cupid.suninternet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Joseph Shraibman wrote:
>
> 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)
Yikes! I didn't see that you had a field and a table with the same
name. Seems to me to be a bad combination. I answered
because the only time I've seen those obscure error messages was
when I accedently put a table name in the select part of a
SELECT query.....
--
Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>
http://cupid.suninternet.com/~kleptog/
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2000-05-26 12:58:40 | Re: What distribution? |
Previous Message | Peter Eisentraut | 2000-05-26 12:51:05 | Re: Creating new user in vers 7.02 and pgaccess |