Date: Fri, 24 Oct 2003 10:37:15 -0600 (MDT)
From: "scott.marlowe" <scott.marlowe@ihs.com>
To: Manuel Sugawara <masm@fciencias.unam.mx>
Cc: Matias Surdi <matiass@interlap.com.ar>,
	<pgsql-sql@postgresql.org>
Subject: Re: Regular expression problem
In-Reply-To: <m3n0bqftz0.fsf@conexa.fciencias.unam.mx>
Message-ID: <Pine.LNX.4.33.0310241036220.24949-100000@css120.ihs.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On 24 Oct 2003, Manuel Sugawara wrote:

> Matias Surdi <matiass@interlap.com.ar> writes:
> 
> > Manuel Sugawara wrote:
> > >Use something like '^[a-z]{2}$'
> > 
> > so, is this a bug????
> 
> No it is not. The sintax you are using is not supported.

It certainly seems to work in Postgresql 7.4 beta 4:

create table test2 (info text);
CREATE TABLE
insert into test2 values ('ab');
INSERT 109169538 1
insert into test2 values ('abc');
INSERT 109169539 1

marl8412=# select * from test2 where info ~ '^[a-z]{2}$';
 info
------
 ab

Or was there more to that message I wasn't getting?