regexp problem

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: regexp problem
Date: 2011-02-24 18:25:43
Message-ID: 482E80323A35A54498B8B70FF2B87980048B56CE39@azsmsx504.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I want to include '[', ']', and '.' in a list of permitted chars in a regexp. This doesn's seem to work...

select 'abc.def[0]' ~ E'^[a-zA-Z0-9_\.\[\]]+$';
?collum?
--------
f
(1 row)

Help!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2011-02-24 18:30:32 Adding a column with constraint
Previous Message Richard Huxton 2011-02-24 17:15:03 Re: database is bigger after dump/restore - why? (60 GB to 109 GB)