Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA2F6xq15029 for ; Fri, 2 Nov 2001 10:07:00 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id fA2FNbc07518; Fri, 2 Nov 2001 10:23:38 -0500 (EST) To: "David M. Richter" cc: Stephan Szabo , pgsql-sql@postgresql.org Subject: Re: View consistency In-reply-to: <3BE25D2F.9BF837EB@dkfz.de> References: <20011101081416.X22509-100000@megazone23.bigpanda.com> <3BE25D2F.9BF837EB@dkfz.de> Comments: In-reply-to "David M. Richter" message dated "Fri, 02 Nov 2001 09:45:35 +0100" Date: Fri, 02 Nov 2001 10:23:37 -0500 Message-ID: <7515.1004714617@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200111/32 X-Sequence-Number: 5417 "David M. Richter" writes: > Select name from patient_view; > is in reality: > Select name from (select ...,...,... from basic where xxx=yyy); > Is that right? Yup. The rule rewriter just substitutes the view definition as a subselect. regards, tom lane