Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA36547 for ; Thu, 5 Aug 1999 10:27:03 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id KAA04104; Thu, 5 Aug 1999 10:26:16 -0400 (EDT) To: rob caSSon cc: pgsql-sql@postgresql.org Subject: Re: [SQL] primary key view failure In-reply-to: Your message of Thu, 5 Aug 1999 09:52:23 -0400 (EDT) Date: Thu, 05 Aug 1999 10:26:16 -0400 Message-ID: <4102.933863176@sss.pgh.pa.us> From: Tom Lane rob caSSon writes: > i have a perfectly valid sql statement that returns expected results, but > when i create a view based on the same sql, i get 0. Your example seems to work fine for me with current sources. What version are you running? regards, tom lane