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 0ADB852867; Thu, 16 Jun 2005 23:07:32 -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 23696-07; Fri, 17 Jun 2005 02:07:29 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 5A57E5283C; Thu, 16 Jun 2005 23:07:28 -0300 (ADT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j5H27TQo069083 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Thu, 16 Jun 2005 20:07:31 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j5H27S1k067616; Thu, 16 Jun 2005 20:07:28 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j5H27Sok067615; Thu, 16 Jun 2005 20:07:28 -0600 (MDT) (envelope-from mfuhr) Date: Thu, 16 Jun 2005 20:07:28 -0600 From: Michael Fuhr To: "Marc G. Fournier" Cc: pgsql-sql@postgresql.org Subject: Re: UPDATEABLE VIEWS ... Examples? Message-ID: <20050617020728.GA67582@winnie.fuhr.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> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/207 X-Sequence-Number: 21808 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 ... Are you looking for "Cooperation with Views" in the "Rules on INSERT, UPDATE, and DELETE" section of the "The Rule System" chapter? http://www.postgresql.org/docs/8.0/static/rules-update.html#RULES-UPDATE-VIEWS -- Michael Fuhr http://www.fuhr.org/~mfuhr/