Received: from orion.SAPserv.Hamburg.dsh.de (Tpolaris2.sapham.debis.de [53.2.131.8]) by hub.org (8.9.2/8.9.1) with SMTP id QAA91145 for ; Wed, 24 Feb 1999 16:59:04 -0500 (EST) (envelope-from wieck@sapserv.debis.de) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@hub.org id m10FmN9-000EBPC; Wed, 24 Feb 99 23:01 MET Message-Id: From: jwieck@debis.com (Jan Wieck) Subject: Re: [SQL] Unable to read from a view To: holston@itd.nrl.navy.mil (Gregory Holston) Date: Wed, 24 Feb 1999 23:01:38 +0100 (MET) Cc: pgsql-sql@hub.org Reply-To: jwieck@debis.com (Jan Wieck) In-Reply-To: from "Gregory Holston" at Feb 24, 99 02:36:47 pm X-Mailer: ELM [version 2.4 PL25] Content-Type: text > > > 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. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #======================================== jwieck@debis.com (Jan Wieck) #