Received: from wallace.ece.rice.edu (root@wallace.ece.rice.edu [128.42.12.154]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA75625 for ; Fri, 18 Feb 2000 13:26:40 -0500 (EST) (envelope-from reedstrm@wallace.ece.rice.edu) Received: by wallace.ece.rice.edu via sendmail from stdin id (Debian Smail3.2.0.102) for pgsql-sql@postgresql.org; Fri, 18 Feb 2000 12:26:31 -0600 (CST) Date: Fri, 18 Feb 2000 12:26:31 -0600 From: "Ross J. Reedstrom" To: Rodrigo Rezende Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Select & Tables X Select & Views Message-ID: <20000218122631.C12742@rice.edu> References: <38AD95C6.C8020910@hortolandia.marelli.it> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0i In-Reply-To: <38AD95C6.C8020910@hortolandia.marelli.it>; from Rodrigo.Rezende@hortolandia.marelli.it on Fri, Feb 18, 2000 at 03:56:06PM -0300 Rodrigo - Are you reporting a bug, or looking for advice? Here's how it works for me: I ran this script: create table taba (a1 int); create table tabb (b1 char); insert into taba (1); insert into taba values (1); insert into taba values (2); insert into taba values (3); insert into tabb values ('a'); insert into tabb values ('b'); create view viewb as select * from tabb; And here are the tests: test=> select version(); version -------------------------------------------------------------- PostgreSQL 6.5.0 on i686-pc-linux-gnu, compiled by gcc 2.7.2.3 (1 row) test=> select * from taba, tabb; a1|b1 --+-- 1|a 2|a 3|a 1|b 2|b 3|b (6 rows) test=> select * from taba, viewb; a1|b1 --+-- 1|a 2|a 3|a 1|b 2|b 3|b (6 rows) test=> So, it looks like your view definition is broken, or your using an old version of pgsql. Ross -- Ross J. Reedstrom, Ph.D., NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005