CREATE OR REPLACE FUNCTION sp_test() RETURNS VOID AS
$BODY$
DECLARE
or_nbr VARCHAR(36) ;
symb VARCHAR(16);
or_action VARCHAR(2);
shar INT;
price NUMERIC(13,6);
st CHAR(1);
event_tim VARCHAR(30);
tra_id VARCHAR(16);
market VARCHAR(10);
cursX CURSOR FOR SELECT * FROM Temp_orders WHERE state='F';
BEGIN
OPEN cursX ;
Loop
FETCH cursX INTO or_nbr,symb,or_action,shar, price, st, event_tim, tra_id, market;
INSERT INTO Layers(order_nbr,symbol,orden_action, shares,order_price,state ,event_time, trader_id, market_id)
VALUES (or_nbr,symb,or_action,shar, price, st, event_tim, tra_id, market) ;
END LOOP;
CLOSE cursX;
END;
$BODY$ LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION sp_test() OWNER TO postgres;
SELECT * FROM sp_test();