Re: SELECT with regular pattern '~' delivers wrong output - Mailing list pgsql-bugs

From Tom Lane
Subject Re: SELECT with regular pattern '~' delivers wrong output
Date
Msg-id 18888.981996727@sss.pgh.pa.us
Whole thread Raw
In response to SELECT with regular pattern '~' delivers wrong output  (Fabio Nanni <f.nanni@albourne.com>)
List pgsql-bugs
Fabio Nanni <f.nanni@albourne.com> writes:
> A SELECT with regular patterns (~) won't give you the right rows.

Strange.  I get only 'Zurich' in both cases, as expected, on HP-PA.
Perhaps an Alpha-specific portability problem in the regex code?
Can anyone else duplicate this misbehavior on other platforms?

            regards, tom lane

> I just found the strange behaviour reported below; I was expecting the
> same response from the last two queries...

> thanks
> Fabio


> LONG DESCRIPTION:
> A SELECT with regular patterns (~) won't give you the right rows.

> CODE SAMPLE:
> select version();
> -- OUTPUT:
> --                              version
> ---------------------------------------------------------------------
> -- PostgreSQL 7.1beta4 on alphaev67-dec-osf4.0f, compiled by cc -std
> --(1 row)


> create table cities (name text);

> insert into cities values ('Alhambra');
> insert into cities values ('Jackson');
> insert into cities values ('Jacksonville');
> insert into cities values ('Zurich');

> select * from cities ;
> -- OUTPUT:
> --     name
> -----------------
> -- Alhambra
> -- Jackson
> -- Jacksonville
> -- Zurich
> --(4 rows)




> select name from cities where name !~ '^A|^B|^C|^[D-I]|^[J][a-c]+kson'
> order by name;
> -- OUTPUT:
> --  name
> ----------
> -- Zurich
> --(1 row)




> select name from cities where name !~
> '^A|^B|^C|^D|^[E-I]|^[J][a-c]+kson' order by name;
> -- OUTPUT:
> --     name
> ----------------
> -- Alhambra
> -- Jackson
> -- Jacksonville
> -- Zurich
> --(4 rows)

pgsql-bugs by date:

Previous
From: Peter T Mount
Date:
Subject: Re: jdbc1 & debug
Next
From: Tom Lane
Date:
Subject: Re: View refuses to work after system reboot