Re: trouble selecting from array

On Fri, Mar 28, 2008 at 2:19 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> 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 result type at parse time, so whether
> there are enough subscripts can't enter into this.) Our alternatives
> here are to throw a subscripting error or return NULL. I'd personally
> have gone with throwing an error, I think, but it seems far too late to
> revisit that decision."
>
> is there not enough information available to the parser to reduce the
> expression dimensions by one?

ugh, I think I see the problem. You have some function that returns
an int[], which does not have a defined number of dimensions, so:

select func()[] is not known to return an int or an int[] at parse
time, so the path of least resistance was to assume 'int'. sorry for
the noise.

merlin