need help with an insert statement

sorry if this becomes a little long, but i want to fully explain the
problem.

three tables;
create table asset(
asset_id serial primary key
);

create table software(
software_id serial primary key
);

create table software_asset(
asset_id integer not null
software_id integer not null
);

what i'm aiming for is to get a function that inserts into the
software_asset table from the software table. i already have a working
function on assets that inserts into software. when that happens, i
need it to set off the function on software to insert into
software_asset. here is the function i am having problems with;

create function soft_asset() returns opaque as '

declare
s software%ROWTYPE;
a assets%ROWTYPE;
sa software_asset%ROWTYPE;
s_id integer;
a_id integer;
asset_id integer;
x integer;

begin

select currval (''assets_asset_id_seq'') into x;
select currval (''software_software_id_seq'') into s_id;

raise notice ''last value = %'', x;
raise notice ''last value = %'', s_id;

insert into software_asset (software_id, asset_id) values (s_id, x);

return null;

end;

create trigger now after insert or update on software
for each row execute procedure soft_asset();

the error happens on the insert statement. if i comment that line out,
it returns a value on the notice, but i can't figure out how to return
that value. if anybody can, i would appreicate their help.

thanks in advance,

mike

--
Mike Zouroudis
Intern
__________________________________________________
I.D.E.A.L. Technology Corporation - Orlando Office
http://www.idealcorp.com - 407.999.9870 x14