Received: from itd.nrl.navy.mil (s2.itd.nrl.navy.mil [132.250.83.3]) by hub.org (8.9.2/8.9.1) with ESMTP id PAA83931 for ; Wed, 24 Feb 1999 15:53:57 -0500 (EST) (envelope-from holston@itd.nrl.navy.mil) Received: from shell (shell [132.250.83.3]) by itd.nrl.navy.mil (8.8.8/8.8.8) with SMTP id OAA21212 for ; Wed, 24 Feb 1999 14:36:47 -0500 (EST) Date: Wed, 24 Feb 1999 14:36:47 -0500 (EST) From: Gregory Holston X-Sender: holston@shell To: pgsql-sql@hub.org Subject: Unable to read from a view Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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