Re: regexp problem

Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> · Thu, 24 Feb 2011 10:39:48 -0800



    On 02/24/2011 10:25 AM, Gauthier, Dave wrote:
    select
'abc.def[0]'
        ~ E'^[a-zA-Z0-9_\.\[\]]+$';
    

    Try:

    E'^[a-zA-Z0-9._\\[\\]]+$'

    
    The "outer" level of parsing turns that into '^[a-zA-Z0-9._\[\]]+$'
    which is the regex you want. Also, I'm *pretty sure* you don't need
    to escape the '.' within a character class.

    
    Cheers,

    Steve