X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 877103A4183 for ; Tue, 23 Nov 2004 23:25:18 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 34886-09 for ; Tue, 23 Nov 2004 23:25:14 +0000 (GMT) Received: from mail.desc.org (splash195.drizzle.com [216.162.197.195]) by svr1.postgresql.org (Postfix) with ESMTP id 4B1923A2BC2 for ; Tue, 23 Nov 2004 23:24:56 +0000 (GMT) Received: from [192.168.6.220] (desktop2.desc.org [192.168.6.220]) by mail.desc.org (8.12.8/8.12.8) with ESMTP id iANNOsUa018125 for ; Tue, 23 Nov 2004 15:24:54 -0800 Message-ID: <41A3C6C6.2090605@desc.org> Date: Tue, 23 Nov 2004 15:24:54 -0800 From: Ken Tanzer Organization: Downtown Emergency Service Center User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7) Gecko/20040618 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: Regexp matching: bug or operator error? Content-Type: multipart/mixed; boundary="------------000903090901090904080802" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/1135 X-Sequence-Number: 69215 This is a multi-part message in MIME format. --------------000903090901090904080802 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Using Postgres V. 7.4.1, the following query: SELECT substring('X12345X' FROM '.*?([0-9]{1,5}).*?'); Returns '1'. I would expect it to return '12345'. Is this a bug, or am I missing something? Thanks. --------------000903090901090904080802 Content-Type: text/x-vcard; charset=utf-8; name="ktanzer.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="ktanzer.vcf" begin:vcard fn:Kenneth Tanzer n:Tanzer;Kenneth org:Downtown Emergency Service Center;Information Services adr:;;507 Third Avenue;Seattle;WA;98104;USA email;internet:ktanzer@desc.org title:IS Manager tel;work:(206) 464-1570 x 3061 tel;fax:(206) 624-4196 url:http://www.desc.org version:2.1 end:vcard --------------000903090901090904080802--