PLPGSQL regexe - Mailing list pgsql-general

From rdear
Subject PLPGSQL regexe
Date
Msg-id 3BA709DD.2020705@dev.internal
Whole thread Raw
List pgsql-general
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?


pgsql-general by date:

Previous
From: "Serge V. Tarasov"
Date:
Subject: Re: adding a superuser
Next
From: Hunter Hillegas
Date:
Subject: Build Problem