Re: Error when using array variable

On Fri, Jul 22, 2005 at 06:24:03PM +0900, Dongsoo Yoon wrote:
>
> When array variable is allocated with any value,
> allocating is not done.

It's not clear what this means -- what are you expecting to happen,
and what actually is happening?

> v_testval := t_modifiedTimes[v_dayIndex ] ; -------------->?????? ?????? ?? ????????
>
> raise exception '???????????? t_modifiedTimes[v_dayIndex ]=', v_testval ;

Is this RAISE just for debugging purposes? Are you aware that you
need to include a % character in the format string if you want to
display the subsequent argument's value?

http://www.postgresql.org/docs/8.0/static/plpgsql-errors-and-messages.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/