please some help on trigger creation

On Mon, Mar 12, 2001 at 11:45:13PM +0100, Feite Brekeveld wrote:

Suppose:

create table rawrecords (
myrec text;
);

create table cookedrecords (
id varchar(10) not null,
name varchar(20) not null,
value integer not null
);

We insert a record say string: "thisid/thisname/12345" into the
rawrecords table.

I would like to have a trigger on that table that splits the raw record
into:

thisid thisname 12345

and inserts those in the cookedrecords table.

It's easy to split such a string using a perl function but how to get
them in the table then ?

<guess factor=blind>
maybe plug items into the NEW pseudorecord...?
similar to a CREATE RULE type of thing?

create rule
add_rec
as on insert to my_view
do instead
insert into my_table (
fullname,
yadayada
) values (
NEW.lastname || ', ' || NEW.firstname,
NEW.something / NEW.somethingelse + NEW.theotherthing
);

</guess>

--
It is always hazardous to ask "Why?" in science, but it is often
interesting to do so just the same.
-- Isaac Asimov, 'The Genetic Code'

will@serensoft.com
http://newbieDoc.sourceforge.net/ -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!