X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 0D7BB30DD97 for ; Fri, 13 Jun 2003 01:57:39 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 21470-04 for ; Thu, 12 Jun 2003 22:57:28 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 56B3230EAA4 for ; Thu, 12 Jun 2003 22:57:28 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h5D1vPU6022504; Thu, 12 Jun 2003 21:57:25 -0400 (EDT) To: weigelt@metux.de Cc: PGSQL-SQL Subject: Re: question on rules In-reply-to: <20030613012611.GA25276@metux.de> References: <20030613012611.GA25276@metux.de> Comments: In-reply-to weigelt@metux.de message dated "Fri, 13 Jun 2003 03:26:11 +0200" Date: Thu, 12 Jun 2003 21:57:25 -0400 Message-ID: <22503.1055469445@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200306/119 X-Sequence-Number: 13877 weigelt@metux.de writes: > i'd like to write an rule which fills out some empty attrs on > insert (w/ data from other given attrs). You'd be better off doing this with a BEFORE INSERT trigger. regards, tom lane