X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id BC39E9DC8AC; Wed, 25 Jan 2006 02:50:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 00915-09; Wed, 25 Jan 2006 02:50:33 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from service-web.de (p15093784.pureserver.info [217.160.106.224]) by postgresql.org (Postfix) with ESMTP id 6CB6B9DC888; Wed, 25 Jan 2006 02:50:30 -0400 (AST) Received: from [192.168.178.99] (p548B3795.dip0.t-ipconnect.de [84.139.55.149]) by service-web.de (Postfix) with ESMTP id 3932920002A; Wed, 25 Jan 2006 07:50:30 +0100 (CET) Message-ID: <43D71FB4.1090009@wildenhain.de> Date: Wed, 25 Jan 2006 07:50:28 +0100 From: Tino Wildenhain User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051017) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: AKHILESH GUPTA Cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: hi all......................!! References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.123 required=5 tests=[AWL=0.123] X-Spam-Score: 0.123 X-Spam-Level: X-Archive-Number: 200601/1240 X-Sequence-Number: 90185 AKHILESH GUPTA schrieb: > hello everybody > i am new to this mailing list. this is my first mail to this group. > i jussst want to confirm that whether is it possible to update a view or > not?? > i think you all help me in solving my queries in future...................!! Yes it is. All you have to do is to add a rule for updating in the way you want it to work. When you use pgadmin3 or such tools, you see that a view is basically a table with one rule for select. For Insert, update you can add a rule any time. HTH Tino Wildenhain