Re: plpgsql function question

It should work pretty much like you have it. You don't need a type;
the table is already a type.

Something like:

create or replace function a_func (in p_row a) returns int as
$$
if p_row.i ...
if p_row.j ...
$$

If it does not work, show the error and I'll try to dig up an example.

John

On Apr 3, 2007, at 2:33 PM, Karthikeyan Sundaram wrote:

> What I want is something like this
> create or replace functinon a_func (in a%rowtype) returns int as
> $$
> ---- do the validation
> $$
> language 'plpgsql';
>
> execute a_func(1, 'good','04/02/2007');

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL