Subqueries

Last week I received help form the list in inserting a serial row of one table (process) into a row in a table called specification.

I was able to expand that to include inserting the same information into a table called pipe.

-------------------

create or replace function base() returns trigger as $$

begin

insert into specification (fluid_id) values (new.fluid_id);

insert into pipe (fluid_id) values (new.fluid_id);

return null;

end;

$$ language plpgsql;

create trigger trig1 after insert on process

for each row execute procedure base();

----------------

This works well.

Now I want to modify the program so that only those rows from process that have ip in the column ip_op_reactor are inserted into pipe.

Following is my best result after studying every piece of documentation available to me.

------------------

create or replace function base() returns trigger as $$

begin

insert into specification (fluid_id) values (new.fluid_id);

select fluid_id as fi from process pr;

select ip_op_reactor as iop from pr ;

select fluid_id as fi from pipe pi

(select fi

from pr where iop = 'ip',

insert into pi (fi) values (new.fi));

return null;

end;

$$ language plpgsql;

create trigger trig1 after insert on process

for each row execute procedure base();

-----------------

This is the error I get.

------------------

ERROR: SELECT query has no destination for result data

HINT: If you want to discard the results, use PERFORM instead.

CONTEXT: PL/pgSQL function "base" line 4 at SQL statement

----------------

I would very much appreciate any help as to where I am going wrong.

Thanks

Bob Pawley