Re: Regular expression problem

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
Cc: Matias Surdi <matiass(at)interlap(dot)com(dot)ar>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Regular expression problem
Date: 2003-10-24 16:37:15
Message-ID: Pine.LNX.4.33.0310241036220.24949-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 24 Oct 2003, Manuel Sugawara wrote:

> Matias Surdi <matiass(at)interlap(dot)com(dot)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?

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Manuel Sugawara 2003-10-24 17:04:03 Re: Regular expression problem
Previous Message Peter Eisentraut 2003-10-24 12:31:26 Re: Error message during compressed backup