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 RAA91977 for ; Wed, 24 Feb 1999 17:03:23 -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 RAA24801; Wed, 24 Feb 1999 17:03:18 -0500 (EST) Date: Wed, 24 Feb 1999 17:03:18 -0500 (EST) From: Gregory Holston X-Sender: holston@shell To: Jan Wieck cc: pgsql-sql@hub.org Subject: Re: [SQL] Unable to read from a view In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Wed, 24 Feb 1999, Jan Wieck wrote: > > > > > > 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, > ^^^^^^^^ > > DISTINCT isn't supported in view definitions. You can SELECT > from view's distinct, but you cannot define them to be. Nor > could you define views with group by and order by. I have tried to drop the view and it gives the same error message. Is there any way to get rid of them (2). Thanks for the help, -Greg