From: Michael Fuhr <mike@fuhr.org>
To: Dongsoo Yoon <dsyoon@metasoftworks.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Error when using array variable
Date: Fri, 22 Jul 2005 07:51:56 -0600
Message-ID: <20050722135156.GA19128@winnie.fuhr.org> (raw)
In-Reply-To: <000601c58e9f$1a3d0cc0$2d216b3d@notebook04>
References: <000601c58e9f$1a3d0cc0$2d216b3d@notebook04>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, dsyoon@metasoftworks.com
Subject: Re: Error when using array variable
In-Reply-To: <20050722135156.GA19128@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox