PL/PGSQL Regexe

From: rdear <rdear(at)dev(dot)internal>
To: pgsql-sql(at)postgresql(dot)org
Subject: PL/PGSQL Regexe
Date: 2001-09-17 15:41:22
Message-ID: 3BA619A2.6090402@dev.internal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Carl van Tast 2001-09-17 18:07:39 Re: group by weirdness
Previous Message Diehl, Jeffrey 2001-09-17 15:36:57 Out of free buffers... HELP!