Hi,
I have an application that receives data with attributes concatenated as
a string seperated by a /
I use perl code to split it into seperate attributes and store it from
one table into another (Solid database)
What I would like to do is:
- Receive the data in a table that stores the cancat. string
- have a trigger on that table that receives splits the string into
pieces using plperl ( some tricky regexps are involved so perl would be
nice )
- have this function insert the new record into another table with the
attibutes seperated.
QUESTION:
Can I call a function from the perl-based trigger to store the new
record ?
Thanks,
Feite Brekeveld