X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1B0F0D1B4CA for ; Sun, 25 Jul 2004 18:14:43 -0300 (ADT) 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 07915-10 for ; Sun, 25 Jul 2004 21:14:41 +0000 (GMT) Received: from web11.manitu.net (web11.manitu.net [217.11.48.111]) by svr1.postgresql.org (Postfix) with ESMTP id D084CD1B4FC for ; Sun, 25 Jul 2004 18:14:37 -0300 (ADT) Received: from [192.168.0.1] (dsl-082-082-215-083.arcor-ip.net [82.82.215.83]) (authenticated) by web11.manitu.net (8.10.2-SOL3/8.10.2) with ESMTP id i6PLEWI04326; Sun, 25 Jul 2004 23:14:32 +0200 Subject: Re: regex engine From: Markus Bertheau To: Tom Lane Cc: Jean-Luc Lachance , Keith Gallant , pgsql-sql@postgresql.org In-Reply-To: <15468.1090784481@sss.pgh.pa.us> References: <1090763779.9204.1.camel@teetnang> <4103C656.4070109@sympatico.ca> <1090772515.9204.3.camel@teetnang> <14659.1090776861@sss.pgh.pa.us> <1090782455.9204.8.camel@teetnang> <15468.1090784481@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8 Message-Id: <1090790072.9204.21.camel@teetnang> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Sun, 25 Jul 2004 23:14:33 +0200 Content-Transfer-Encoding: quoted-printable 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: 200407/221 X-Sequence-Number: 18473 =D0=92 =D0=92=D1=81=D0=BA, 25.07.2004, =D0=B2 21:41, Tom Lane =D0=BF=D0=B8= =D1=88=D0=B5=D1=82: > Markus Bertheau writes: > > pg's regex engine does have one > > shortcoming though: it doesn't know UTF-8. >=20 > Sure it does. We borrowed it from Tcl, remember? >=20 > The "character class" stuff is not locale-aware at the moment, > which is something that ought to get fixed eventually, but claiming > it doesn't handle UTF8 at all is simply wrong. Turns out I tested in a SQL_ASCII database. Sorry :) --=20 Markus Bertheau