thank you for answering my question. it didn't work quite as expected
though. the insert statement just doesn't want to work. what i ended
up doing is using a select into statement to assign variables to both
ids', like this;
select currval (''mom_mom_id_seq'') into x;
select currval (''dad_dad_id_seq'')into y;
raise notice ''last value of mom_id %'' x;
raise notice ''last value of dad_id %'' y;
this returns a value for both x and y. when an insert statement is
added though;
insert into mom_dad(mom_id, dad_id) values (x, y);
i get an error message that says there is a parse error at
or near $1. i suppose the argurment causing the error is the insert,
since this message does not come up when i comment it out. if i'm doing
something wrong, i don't know what. please help.
thanks again in advance,
mike zouroudis
--
Mike Zouroudis
Intern
__________________________________________________
I.D.E.A.L. Technology Corporation - Orlando Office
http://www.idealcorp.com - 407.999.9870 x14
--