i want to be able to create a trigger such that when i insert information in one table, two other tables will also get a value inserted. when i looked at the documentation for triggers and functions (which i personally find daunting), i found out about pl/pgsql and creating functions. but how do i pass a parameter from the trigger to the function? peter choe ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
