Message-ID: <3EE9FC23.8020206@Yahoo.com>
Date: Fri, 13 Jun 2003 12:30:27 -0400
From: Jan Wieck <JanWieck@Yahoo.com>
Organization: Unorganized
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.0.2) Gecko/20030208 Netscape/7.02
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: weigelt@metux.de, PGSQL-SQL <pgsql-sql@postgresql.org>
Subject: Re: question on rules
References: <20030613012611.GA25276@metux.de> <22503.1055469445@sss.pgh.pa.us>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Tom Lane wrote:
> 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.

The only way to do it with rules would be to create a view over the 
basetable, create an insert rule over the view and then have the 
application doing the insert into the view instead. So "better" could be 
considered an understatement :-)


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #