Code:
create or replace function p1() returns trigger as $body$ begin --- update fixed_asset set circle_id=Irrigation_potential_details.circle_id from Irrigation_potential_details where fixed_asset.division_id =Irrigation_potential_details.division_id; update minor_scheme_details set circle_id=Irrigation_potential_details.circle_id from Irrigation_potential_details where minor_scheme_details.division_id=Irrigation_potential_details.division_id; update consumer_additional_details set circle_id=Irrigation_potential_details.circle_id from Irrigation_potential_details where consumer_additional_details.division_id= Irrigation_potential_details.division_id; return null; end $body$ language plpgsql -----------------