Re: [SQL] PL/PGSQL Regexe

[rdear]

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

Thanks!


Tom Lane wrote:

[EMAIL PROTECTED]">

rdear <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED])