[SQL] PL/PGSQL Regexe

2001-09-19 Thread rdear 

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. Any suggestions 
or is this a bug/feature?



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [SQL] PL/PGSQL Regexe

2001-09-27 Thread 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 errormessage 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])