[postgis-users] How to assign values to a bimensional array?

[Eduardo Patto Kanegae]

Hi folks,

I'm trying to develop a PL/PgSQL function to calculate inverse T distribution , just like INVT() does at MS Excel.

then I declare a tow-dimension array like this:

...

DECLARE
  TDist numeric(6,3)[35][14]; -- 35 row X 14 columns
BEGIN..

but when trying to set values to this array using:

TDist[0][0] := myvalue1;
TDist[0][1] := myvalue2;
...
TDist[34][13] := myvalueN;
....

it fails! no value is assigned to any of the array addresses.

what am I doing wrong?

best regards,

Eduardo Patto Kanegae
http://www.webmapit.com.br
ICQ: 303747254

Treinamento em UMN MapServer - http://www.webmapit.com.br/ptbr/?menuoption=mapserver
Fórum MapServer Brasil - http://mapserver.cttmar.univali.br/forum

***Fim da Mensagem / End of Message ***