Re: multidimensional arrays

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mstory(at)uchicago(dot)edu
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: multidimensional arrays
Date: 2005-02-03 04:56:58
Message-ID: 11733.1107406618@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

mstory(at)uchicago(dot)edu writes:
> I'm writing a 2 dimensional array INTEGER[3][] that holds data that i
> need to parse through to check for zeros. The user will insert into
> this array one row at a time, when i insert the first row into this
> array it works fine but when i check array_dims it gives me [1:3] not
> the [1:3][1:1] that i expected,

You assigned a one-dimensional value to the array, not a two-dimensional
value.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Hall 2005-02-03 05:56:25 Lost rows / corrupt data?
Previous Message Alex Turner 2005-02-03 03:31:26 Re: Problems with filter on timestamp