Unable to read from a view

Поиск
Список
Период
Сортировка
От Gregory Holston
Тема Unable to read from a view
Дата
Msg-id Pine.SUN.3.91.990224143207.20096A-100000@shell
обсуждение исходный текст
Ответы Re: [SQL] Unable to read from a view
Список pgsql-sql
Hi all,

I just created a view and have been unable to read from it.  I am
Apache/1.3.1 (Unix) PHP/3.0.3 and Postgres 6.4.  When I tried to do a
select it gives the following error message:

real=> select * from pubsearch;
ERROR:  nodeRead: Bad type 0

I created the view with the following select statment:

select distinct users.firstname, users.lastname, publication.title,
publication.publisher, publication.year from
publication, authors, users
where users.id = authors.id and authors.pubrelease =
publication.pubrelease;

firstname is type text
lastname is type text
title is type text
year is type text

Thanks in advance for all your help,

-Greg

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

Предыдущее
От: "Dr. Nisai Wanakule"
Дата:
Сообщение: PL/Perl?
Следующее
От: jwieck@debis.com (Jan Wieck)
Дата:
Сообщение: Re: [SQL] Unable to read from a view