PLPGSQL regexe

From: rdear <rdear(at)dev(dot)internal>
To: pgsql-general(at)postgresql(dot)org
Subject: PLPGSQL regexe
Date: 2001-09-18 08:46:21
Message-ID: 3BA709DD.2020705@dev.internal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Browse pgsql-general by date

  From Date Subject
Next Message Haller Christoph 2001-09-18 09:40:40 Re: MySQL development MUST immdediately cease - Due to
Previous Message Alessio Bragadini 2001-09-18 07:40:32 Re: Ridicolus Postgresql review