Re: Help with function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris Hoover <revoohc(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Help with function
Date: 2005-08-12 18:57:54
Message-ID: 21888.1123873074@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Chris Hoover <revoohc(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Lane 2005-08-12 20:23:01 Log stdout in PG 8?
Previous Message Tom Lane 2005-08-12 18:55:01 Re: pg_restore