Hi,
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 ?
Seperate functions to get each attribute ? seems quite expensive !
Am I overlooking some posibilities here ?
Thanks,
Feite Brekeveld