Re: Regex escape [ character and change text result into

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
>