CREATE OR REPLACE FUNCTION prd_db_dm."03_load_objects_with_squares_1st"(in_city integer)
RETURNS integer AS $$
DECLARE v_flag integer;
        v_city integer;
BEGIN

select in_city into v_city;

if v_city>=1 then 

insert into prd_db_dm."03_objects_with_squares_1st" (
  city
) 
select 
  a.city
from prd_db_stg."03_objects_with_squares_1st" a
where a.city = v_city;
commit;

v_flag := 1;
return v_flag;

end if;

exception when others then
begin
v_flag:=0;
return v_flag;
end;

END;
$$ LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION prd_db_dm."03_load_objects_with_squares_1st"(integer)
  OWNER TO admin;