Hi,
I guess there is some misunderstanding from my question
Let me elaborate more clearly.
My Table is
Create table a (
i int,
j varchar(20),
k date);
Create or replace function a_func (in p_i int, in p_j varchar, in p_k date) returns int as
$$
----- do the validation
return 1;
$$
language 'plpgsql';
This works fine
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');
> Date: Tue, 3 Apr 2007 20:18:43 +0200> From: akretschmer(at)spamfence(dot)net> To: pgsql-sql(at)postgresql(dot)org> Subject: Re: [SQL] plpgsql function question> > Karthikeyan Sundaram <skarthi98(at)hotmail(dot)com> schrieb:> > > > > Hi,> > > > I am having a requirement here.> > > > 1) I need to write a plpgsql function where it takes the input> > parameter of a structure of a table.> > Because? To build this table? You can pass an ascii-text with the> table-definition and EXECUTE this string.> > > > 2) The table has 15 columns> > Okay. And the problem is?> > > > 3) It does lots of validation based on the parameter and finally> > returns an integer as output parameters> > Okay. create function ... returns int as $$ ... return 1; end; $$> language plpgsql;> > > > > > Q) How will I passe the table structure as as parameter> > As i said, for instance as simple text and EXECUTE this.> > > > 2) Do I need to create a type?> > No.> > > Andreas> -- > Really, I'm not out to destroy Microsoft. That will just be a completely> unintentional side effect. (Linus Torvalds)> "If I was god, I would recompile penguin with --enable-fly." (unknow)> Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°> > ---------------------------(end of broadcast)---------------------------> TIP 9: In versions below 8.0, the planner will ignore your desire to> choose an index scan if your joining column's datatypes do not> match
_________________________________________________________________
i'm making a difference. Make every IM count for the cause of your choice. Join Now.
http://clk.atdmt.com/MSN/go/msnnkwme0080000001msn/direct/01/?href=http://im.live.com/messenger/im/home/?source=wlmailtagline