Ok, here is a bit more information, When I declare the function as function(view_name, view_name) an try to update my view. I am getting the following errors: ERROR: record type has not been registered CONTEXT: PL/pgSQL function "clmhdr_view_update" while storing call arguments into local variables My rule is doing select function_name(new.*, old.*). What is pg trying say here, and how to I modify my function to fix this? Thanks, Chris On 8/12/05, Chris Hoover <revoohc@xxxxxxxxx> wrote: > I need some help with how to define a function. I am trying to create > a function that I pass two records into. However, I can not seem to > get the syntax correct in the definition. > > Exactly what I'm doing is having a rule on one of my views call a > function and pass the new.* and old.* records to the function. the > function will then handle the inserting, updating, and deleting from > the underlying tables. > > 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? > > thanks, > > Chris >
