Re: Help with function - Mailing list pgsql-admin

From Tom Lane
Subject Re: Help with function
Date
Msg-id 21888.1123873074@sss.pgh.pa.us
Whole thread Raw
In response to Help with function  (Chris Hoover <revoohc@gmail.com>)
List pgsql-admin
Chris Hoover <revoohc@gmail.com> 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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_restore
Next
From: Steve Lane
Date:
Subject: Log stdout in PG 8?