i waana create parameterized function with trigger its simple function which is help

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • prashant16
    New Member
    • Oct 2013
    • 1

    i waana create parameterized function with trigger its simple function which is help

    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
    -----------------
    Last edited by Rabbit; Oct 29 '13, 03:39 PM. Reason: Please use [CODE] and [/CODE] tags when posting code or formatted data.
Working...