Received: from flex.flex.ro ([193.230.255.4]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA98415; Wed, 19 May 1999 09:45:14 -0400 (EDT) (envelope-from teo@flex.ro) Received: from flex.ro (IDENT:teo@teo.flex.ro [193.230.255.3]) by flex.flex.ro (8.9.1/8.9.1) with ESMTP id PAA29886; Wed, 19 May 1999 15:44:43 +0300 Sender: teo@flex.flex.ro Message-ID: <3742C185.F57328C0@flex.ro> Date: Wed, 19 May 1999 13:49:57 +0000 From: Constantin Teodorescu Organization: FLEX Consulting X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.2.6 i586) X-Accept-Language: en MIME-Version: 1.0 To: PostgreSQL Interfaces , "pgsql-hackers@postgreSQL.org" Subject: Broken select on regular expression !!! Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, I think I have found a bug in regexp based selections. Watch this : create table regdemo (fld1 varchar(32)); CREATE insert into regdemo values('410'); INSERT 726409 1 insert into regdemo values('7410'); INSERT 726410 1 insert into regdemo values('source'); INSERT 726411 1 insert into regdemo values('destination'); INSERT 726412 1 select * from regdemo where fld1 ~* '^sou|^des'; fld1 ----------- source destination (2 rows) select * from regdemo where fld1 ~* '41|^des'; fld1 ----------- 410 7410 destination (3 rows) select * from regdemo where fld1 ~* '^41|^des'; fld1 ---- (0 rows) ^^^^^^^^^^^^^^ !?!?!?! I thought it should return '410' and 'destination' rows. But it returns nothing! The first select example with ^ in both variants ( ^sou|^des ) works !!! The last one ( ^41|^des ) don't ! Am I missing something? I am getting the same result also on 6.4.2 and 6.5 beta 1 versions! Best regards, -- Constantin Teodorescu FLEX Consulting Braila, ROMANIA