Re: PL/PGSQL Regexe

Humm... 7.0.2, I'll upgrade and try again.

Thanks!

Tom Lane wrote:

> rdear <rdear(at)dev(dot)internal> writes:
>
>> I'm doing a check within a PL/PGSQL function using a regular expression
>> and I get the error:
>
>> ERROR: regcomp failed with error invalid character range
>
>> This appears to be because of the underscore "_" character. The regex I
>> want to use is ''[A-Za-z0-9_]'' but this doesn't work.
>
>
> Seems to work for me:
>
> regression=# select 'a' ~ '[A-Za-z0-9_]';
> ?column?
> ----------
> t
> (1 row)
>
> regression=# select '_' ~ '[A-Za-z0-9_]';
> ?column?
> ----------
> t
> (1 row)
>
> regression=# select ':' ~ '[A-Za-z0-9_]';
> ?column?
> ----------
> f
> (1 row)
>
> How old is your Postgres? (I can tell by the spelling of the error
> message that it's not current.)
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)