Re: Regular expression problem - Mailing list pgsql-sql

From scott.marlowe
Subject Re: Regular expression problem
Date
Msg-id Pine.LNX.4.33.0310241036220.24949-100000@css120.ihs.com
Whole thread Raw
In response to Re: Regular expression problem  (Manuel Sugawara <masm@fciencias.unam.mx>)
Responses Re: Regular expression problem
Re: Regular expression problem
List pgsql-sql
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?



pgsql-sql by date:

Previous
From: Manuel Sugawara
Date:
Subject: Re: Regular expression problem
Next
From: Manuel Sugawara
Date:
Subject: Re: Regular expression problem