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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
