Error when using array variable

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;

Responses

Browse pgsql-sql by date

  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?