Unable to read from a view - Mailing list pgsql-sql

From Gregory Holston
Subject Unable to read from a view
Date
Msg-id Pine.SUN.3.91.990224143207.20096A-100000@shell
Whole thread Raw
Responses Re: [SQL] Unable to read from a view  (jwieck@debis.com (Jan Wieck))
List 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 by date:

Previous
From: "Dr. Nisai Wanakule"
Date:
Subject: PL/Perl?
Next
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [SQL] Unable to read from a view