Message-ID: <20031024184320.45589.qmail@web20802.mail.yahoo.com>
Date: Fri, 24 Oct 2003 11:43:20 -0700 (PDT)
From: Jeff Eckermann <jeff_eckermann@yahoo.com>
Subject: Re: Regular expression problem
To: "scott.marlowe" <scott.marlowe@ihs.com>
Cc: Matias Surdi <matiass@interlap.com.ar>, pgsql-sql@postgresql.org
In-Reply-To: <Pine.LNX.4.33.0310241036220.24949-100000@css120.ihs.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

7.4 uses a completely new regex engine, so comparisons
with that will not be valid anyway.
Pre-7.4 regex behaviour is all documented:
Users Guide -> Functions & Operators -> Pattern
Matching

--- "scott.marlowe" <scott.marlowe@ihs.com> wrote:
> 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?
> 
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)


__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com