Skip site navigation (1) Skip section navigation (2)

Re: SELECT with regular pattern '~' delivers wrong output

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fabio Nanni <f(dot)nanni(at)albourne(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-ports(at)postgresql(dot)org
Subject: Re: SELECT with regular pattern '~' delivers wrong output
Date: 2001-02-12 16:52:07
Message-ID: 18888.981996727@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-ports
Fabio Nanni <f(dot)nanni(at)albourne(dot)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)

In response to

pgsql-ports by date

Next:From: Jason TishlerDate: 2001-02-12 18:12:48
Subject: Re: Cygwin postmaster exit problem?
Previous:From: Peter EisentrautDate: 2001-02-12 16:13:35
Subject: Re: database creation failed

pgsql-bugs by date

Next:From: Tom LaneDate: 2001-02-12 17:05:56
Subject: Re: View refuses to work after system reboot
Previous:From: Peter T MountDate: 2001-02-12 14:50:29
Subject: Re: jdbc1 & debug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group