X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AD13952861; Thu, 16 Jun 2005 22:04:27 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95433-09; Fri, 17 Jun 2005 01:04:25 +0000 (GMT) Received: from a.mail.sonic.net (a.mail.sonic.net [64.142.16.245]) by svr1.postgresql.org (Postfix) with ESMTP id B76D45283C; Thu, 16 Jun 2005 22:04:23 -0300 (ADT) Received: from cookie.varlena.com (64-142-36-103.dsl.static.sonic.net [64.142.36.103]) by a.mail.sonic.net (8.13.3/8.13.3) with ESMTP id j5H14RnS001022; Thu, 16 Jun 2005 18:04:27 -0700 Received: by cookie.varlena.com (Postfix, from userid 1000) id 6FB4ACCE; Thu, 16 Jun 2005 18:04:52 -0700 (PDT) Date: Thu, 16 Jun 2005 18:04:52 -0700 To: "Marc G. Fournier" Cc: pgsql-sql@postgresql.org Subject: Re: UPDATEABLE VIEWS ... Examples? Message-ID: <20050617010452.GE30133@varlena.com> Mail-Followup-To: "Marc G. Fournier" , pgsql-sql@postgresql.org References: <20050616180356.Y90456@ganymede.hub.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050616180356.Y90456@ganymede.hub.org> User-Agent: Mutt/1.5.6+20040907i From: elein@varlena.com (elein) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.054 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/205 X-Sequence-Number: 21806 There is a write up on these at: http://www.varlena.com/GeneralBits/82.php --elein ============================================================ elein@varlena.com Varlena, LLC www.varlena.com PostgreSQL Consulting, Support & Training PostgreSQL General Bits http://www.varlena.com/GeneralBits/ ============================================================= I have always depended on the [QA] of strangers. On Thu, Jun 16, 2005 at 06:05:03PM -0300, Marc G. Fournier wrote: > > Reading through the docs, both the CREATE VIEW and CREATE RULE pages refer > to how you can use a RULE to 'simulate' an updateable VIEW ... but I can't > seem to find any examples of this ... > > Does anyone know of an online example of doing this that I can read > through? > > Thanks ... > > ---- > Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) > Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664 > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match >