Re: Error when using array variable - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: Error when using array variable
Date
Msg-id 20050722135156.GA19128@winnie.fuhr.org
Whole thread Raw
In response to Error when using array variable  ("Dongsoo Yoon" <dsyoon@metasoftworks.com>)
List pgsql-sql
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/


pgsql-sql by date:

Previous
From: Pascual De Ruvo
Date:
Subject: Re: Using subselects as joins in POstgeSQL (possible?, examples)
Next
From: lucas@presserv.org
Date:
Subject: Convert numeric to money