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