To: "scott.marlowe" <scott.marlowe@ihs.com>
Cc: Matias Surdi <matiass@interlap.com.ar>,
	<pgsql-sql@postgresql.org>
Subject: Re: Regular expression problem
References: <Pine.LNX.4.33.0310241036220.24949-100000@css120.ihs.com>
In-Reply-To: <Pine.LNX.4.33.0310241036220.24949-100000@css120.ihs.com>
From: Manuel Sugawara <masm@fciencias.unam.mx>
User-Name: Manuel Sugawara
User-Mail-Address: masm@fciencias.unam.mx
Date: 24 Oct 2003 12:16:54 -0600
Message-ID: <m38ynapkkp.fsf@conexa.fciencias.unam.mx>
Lines: 23
User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.4 (Portable Code)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

"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.

Regards,
Manuel.