Re: order of (escaped) characters in regex range

True, but still weird...

And are you sure it does the same thing?

2011/12/13 Szymon Guz <mabewlun(at)gmail(dot)com>

>
>
> On 13 December 2011 14:04, InterRob <rob(dot)marjot(at)gmail(dot)com> wrote:
>
>> Dear List,
>>
>> I found this interesting:
>>
>> SELECT regexp_matches('123-A' , E'(3[A-Z\- ])');
>> ERROR: invalid regular expression: invalid character range
>>
>> whereas:
>> SELECT regexp_matches('123-A' , E'(3[\- A-Z])');
>> regexp_matches
>> ----------------
>> {3-}
>> (1 row)
>>
>> Notice the order of (escaped) characters and ranges in the last bit of
>> the expression.
>>
>> Am I missing some key concept of the regular expression?
>>
>> Regards,
>> Rob
>>
>
> Hi Rob,
> try '\\-' instead of '\-'
> and it works :)
>
> regards
> Szymon
>