Re: [GENERAL] multidimensional arrays

2007-05-02 Thread Ketema
On May 1, 10:48 pm, [EMAIL PROTECTED] (Tom Lane) wrote: > Ketema <[EMAIL PROTECTED]> writes: > > Is it possible to access a subarray of a multi dimensional array as a > > whole? > > I think you want an array slice (ie, something with some colons in the > subscripts). See the > manual:http://www.p

Re: [GENERAL] multidimensional arrays

2007-05-01 Thread Tom Lane
Ketema <[EMAIL PROTECTED]> writes: > Is it possible to access a subarray of a multi dimensional array as a > whole? I think you want an array slice (ie, something with some colons in the subscripts). See the manual: http://www.postgresql.org/docs/8.2/static/arrays.html re

[GENERAL] multidimensional arrays

2007-05-01 Thread Ketema
Is it possible to access a subarray of a multi dimensional array as a whole? example: '{ { {1,2,3}, {11,22,33}, {111,222,333} }, { {4,5,6}, {44,55,66}, {444,555,666} }, { {7,8,9}, {77,88,99}, {777,888,999}

Re: [GENERAL] multidimensional arrays

2005-02-02 Thread Tom Lane
[EMAIL PROTECTED] 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 m

[GENERAL] multidimensional arrays

2005-02-02 Thread mstory
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