Re: [GENERAL] multiple statement 'instead of' rule

2006-06-21 Thread Merlin Moncure
On 6/20/06, Tom Lane <[EMAIL PROTECTED]> wrote: "Merlin Moncure" <[EMAIL PROTECTED]> writes: > create or replace rule insert_fsv as on insert to frequency_service_view > do instead > ( > insert into frequency_operation > select new.table_name, new.frequency, old.code where new.set =

Re: [GENERAL] multiple statement 'instead of' rule

2006-06-20 Thread Tom Lane
"Merlin Moncure" <[EMAIL PROTECTED]> writes: > create or replace rule insert_fsv as on insert to frequency_service_view > do instead > ( > insert into frequency_operation > select new.table_name, new.frequency, old.code where new.set = > true and old.set = false; > delete from fre