Re: Help with function

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(at)gmail(dot)com> 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
>