Unable to read from a view

From: Gregory Holston <holston(at)itd(dot)nrl(dot)navy(dot)mil>
To: pgsql-sql(at)hub(dot)org
Subject: Unable to read from a view
Date: 1999-02-24 19:36:47
Message-ID: Pine.SUN.3.91.990224143207.20096A-100000@shell
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Wieck 1999-02-24 22:01:38 Re: [SQL] Unable to read from a view
Previous Message Dr. Nisai Wanakule 1999-02-24 17:03:31 PL/Perl?