please some help on trigger creation - Mailing list pgsql-general

    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