I use a function using array variable as following. The function returns array type. When array variable is allocated with any value,allocating is not done. I can't find why it is. ------------------------------------------------------- CREATE OR REPLACE FUNCTION arr_test() RETURNS NUMERIC[] AS $BODY$ DECLARE v_count NUMERIC default 0; v_dayIndex NUMERIC default 0; t_modifiedTimes NUMERIC[]; v_testval NUMERIC default 0; .... BEGIN .... for v_count in 1..5 loop v_dayIndex := v_dayIndex + 1;
t_modifiedTimes[v_dayIndex ] := v_count;
v_testval := t_modifiedTimes[v_dayIndex ] ; -------------->배열에 저장된 값 임시저장 raise exception '임의에러생성 t_modifiedTimes[v_dayIndex ]=', v_testval ; -------------->강제적으로 exception 발생시킴 end loop; .... return t_modifiedTimes; END; $BODY$ LANGUAGE plpgsql;
pgsql-sql by date:
Соглашаюсь с условиями обработки персональных данных