From: scott.marlowe <scott.marlowe@ihs.com>
To: Manuel Sugawara <masm@fciencias.unam.mx>
Cc: Matias Surdi <matiass@interlap.com.ar>
Cc: pgsql-sql@postgresql.org
Subject: Re: Regular expression problem
Date: Fri, 24 Oct 2003 11:44:26 -0600 (MDT)
Message-ID: <Pine.LNX.4.33.0310241144180.25425-100000@css120.ihs.com> (raw)
In-Reply-To: <m38ynapkkp.fsf@conexa.fciencias.unam.mx>
On 24 Oct 2003, Manuel Sugawara wrote:
> "scott.marlowe" <scott.marlowe@ihs.com> writes:
>
> > 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?
>
> He was trying to use '[a-z]{2,2}', which doesn't work in PostgreSQL.
Oh, ok. Thanks.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: scott.marlowe@ihs.com, masm@fciencias.unam.mx, matiass@interlap.com.ar
Subject: Re: Regular expression problem
In-Reply-To: <Pine.LNX.4.33.0310241144180.25425-100000@css120.ihs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox