Hi Tom. I misread the manual. I thought I could not do array_upper on
multidimensional array but it was specific concatenation functions.
Thank you for clarifying this.
Regards,
David
On Tuesday, July 5, 2005, at 01:22 PM, Tom Lane wrote:
> David Pratt <fairwinds@eastlink.ca> writes:
>> Hi. I am using array_dims to give me dimensions of multidimensional
>> array ie:
>
>> [1:5][1:2]
>
>> In my function I want to retreive the value of the second number from
>> array_dims (5 in example above)
>
> Why aren't you using array_upper()?
>
>> This is what I am trying:
>> count_str = substr(dimensions from '\[\d\:(\d+)\]\[\d\:\d\]')
>
> Perhaps you forgot to double the backslashes?
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>