CREATE OR REPLACE FUNCTION ch_createlines()
RETURNS void AS
$BODY$ DECLARE 
  lineId VARCHAR(32);
  BEGIN
   select m_ch_value_id
     into lineId
    from m_ch_value 
    order by created desc limit 1;
    


	FOR x IN 1..200
	LOOP   	
	raise notice '%', x;
		INSERT INTO m_ch_value (m_ch_value_id, ad_client_id, ad_org_id, isactive, created, createdby, 
			updated, updatedby, m_characteristic_id, name, issummary, skcode, description, add_products)
			(SELECT get_uuid(), ad_client_id, ad_org_id, isactive, created, createdby, 
			updated, updatedby, m_characteristic_id, get_uuid(), issummary, skcode, description, add_products
			FROM m_ch_value WHERE m_ch_value_id = lineid);
	END LOOP;

END ; $BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;