A QUESTION ABOUT evaluation of two-dimensional Associative Arrays

From: "superzhangfei" <superzhangfei(at)aliyun(dot)com>
To: "Kevin Grittner" <kgrittn(at)ymail(dot)com>
Cc: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: A QUESTION ABOUT evaluation of two-dimensional Associative Arrays
Date: 2013-08-27 13:24:26
Message-ID: e55a6d49-f23c-473f-9582-b8065e89dff6@aliyun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello
This is Robin.
I'm learning about the package of Enterprisedb.
I wrote a package like:CREATE OR REPLACE PACKAGE BODY pkg_test_d2IS
TYPE t_d2_tab IS TABLE OF integer INDEX BY integer;TYPE t_d2_arr IS TABLE OF t_d2_tab INDEX BY integer;
v_D2_Value t_d2_arr;v_D2_Max integer DEFAULT 0;
PROCEDURE xxx(INOUT xxxx) ISBEGIN  ...  cnt := 1;  LOOP   cnt := cnt + 1;  IF XXX
   v_D2_Value(v_D2_Max)(cnt) := 0;   END IF;   ....     
But it can not be excused.I modified v_D2_Value(v_D2_Max)(cnt)  to v_D2_Value[v_D2_Max][cnt].So it can be load in to database.When the package be excused,an error occured.
I need a way to give a value to the variable v_D2_Value  directly,which like v_D2_Value(v_D2_Max)(cnt) := 0  .
Could you give me some advice please?
 
Best Regards

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2013-08-27 15:12:32 OLAP
Previous Message Yelai, Ramkumar IN BLR STS 2013-08-27 08:34:05 Pgbouncer help