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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
