From: | "Dongsoo Yoon" <dsyoon(at)metasoftworks(dot)com> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Error when using array variable |
Date: | 2005-07-22 09:24:03 |
Message-ID: | 000601c58e9f$1a3d0cc0$2d216b3d@notebook04 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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;
From | Date | Subject | |
---|---|---|---|
Next Message | Gnanavel S | 2005-07-22 09:37:04 | Re: Error when using array variable |
Previous Message | Dongsoo Yoon | 2005-07-22 06:30:22 | Is there a type like a growable array, similar Vector at Java language in postgreSQL? |