On Fri, Mar 28, 2008 at 2:19 PM, Merlin Moncure <[EMAIL PROTECTED]> wrote:
> reading the archives, you wrote:
> "Because it isn't a slice expression --- you used colon nowhere, so the
> result type is going to be text not text[]. (Remember that the parser
> must determine the expression's resu
On Thu, Mar 27, 2008 at 8:58 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> If you want a sub-array you need to use the slice notation, eg
> tdr_tags[2:2][1:2]
The slice approach is not a general solution...in fact there seems to
be no way to convert an array of N dimensions to N-1 dimensions except
Tom Lane wrote:
brian <[EMAIL PROTECTED]> writes:
If I select the column as tdr_tags I get:
{{161377},{32}}
{{206507},{39}}
{{232972,292831},{45,51}}
...
But, wanting just the 2nd inner array, if I try tdr_tags[2] I get NULL.
If you want a sub-array you need to use the slice notation, eg
brian <[EMAIL PROTECTED]> writes:
> If I select the column as tdr_tags I get:
> {{161377},{32}}
> {{206507},{39}}
> {{232972,292831},{45,51}}
> ...
> But, wanting just the 2nd inner array, if I try tdr_tags[2] I get NULL.
If you want a sub-array you need to use the slice notation, eg
tdr_tags[2
Using 8.3
I have a table which has a column (tdr_tags) defined as integer[][]. The
table description shows the column as integer[]. I understand from the
docs that this is normal ("declaring number of dimensions or sizes in
CREATE TABLE is simply documentation").
If I select the column as td
