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

Поиск
Список
Период
Сортировка
От Joseph Shraibman
Тема Re: problem with NOTICE: _outNode: don't know how to print type
Дата
Msg-id 392D95AC.8E813279@selectacast.net
обсуждение исходный текст
Ответ на problem with NOTICE: _outNode: don't know how to print type  (Ari Jolma <ajolma@water.hut.fi>)
Список 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)

В списке pgsql-general по дате отправления:

Предыдущее
От: Marcos Barreto de Castro
Дата:
Сообщение: Limits on PostgreSQL
Следующее
От: Peter Landis
Дата:
Сообщение: postgresql and perl?