From: | David Pratt <fairwinds(at)eastlink(dot)ca> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Regex escape [ character and change text result into |
Date: | 2005-07-05 17:10:31 |
Message-ID: | B15487F0-ED77-11D9-A19D-000A27B3B070@eastlink.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)eastlink(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dann Corbit | 2005-07-05 17:20:16 | Re: How can this be optimized, if possible? |
Previous Message | Jaime Casanova | 2005-07-05 16:58:19 | default tablespaces |