| 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: | Whole Thread | Raw Message | 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?
| 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 |