Re: Regex escape [ character and change text result into integer - Mailing list pgsql-general

From Tom Lane
Subject Re: Regex escape [ character and change text result into integer
Date
Msg-id 23620.1120580577@sss.pgh.pa.us
Whole thread Raw
In response to Regex escape [ character and change text result into integer  (David Pratt <fairwinds@eastlink.ca>)
Responses Re: Regex escape [ character and change text result into
List pgsql-general
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

pgsql-general by date:

Previous
From: David Pratt
Date:
Subject: Regex escape [ character and change text result into integer
Next
From: Jaime Casanova
Date:
Subject: default tablespaces