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

Re: [SQL] PL/PGSQL Regexe

2001-09-19 Thread Tom Lane
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

[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