Chris Hoover <revoohc@xxxxxxxxx> writes: > I tried to define the function as function_name(new_rec view_name, > old_rec view_name), but it abends on the call. > function_name(new_rec view_name%rowtype, old_rec view_name%rowtype) > will not compile. > Can someone please provide some guidance on how to pass the records to > my new function? Not when you're being so parsimonious with details. Show us the full text of the function and the exact error message you got. Also, I forget which Postgres version you are using --- it matters. regards, tom lane