X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6A97CD6F60 for ; Mon, 5 Sep 2005 14:31:51 -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 49716-10 for ; Mon, 5 Sep 2005 17:31:46 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 8C4E6D6F0D for ; Mon, 5 Sep 2005 14:31:46 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j85HVi5g001898; Mon, 5 Sep 2005 13:31:45 -0400 (EDT) To: Peter Eisentraut Cc: Harald Fuchs , pgsql-sql@postgresql.org Subject: Re: POSIX Regular Expression question In-reply-to: <200509051815.22529.peter_e@gmx.net> References: <431C4EB2.80401@mediaroot.de> <200509051619.29210.peter_e@gmx.net> <87k6hv7cay.fsf@srv.protecting.net> <200509051815.22529.peter_e@gmx.net> Comments: In-reply-to Peter Eisentraut message dated "Mon, 05 Sep 2005 18:15:21 +0200" Date: Mon, 05 Sep 2005 13:31:44 -0400 Message-ID: <1897.1125941504@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200509/40 X-Sequence-Number: 22587 Peter Eisentraut writes: > Am Montag, 5. September 2005 17:40 schrieb Harald Fuchs: >> I dunno the details of the supported encodings, but is there >> any encoding where 'a-z' includes more or less than 26 letters? > Well, it seems that our regexp library interprets [a-z] as exactly 26 letters, > but that seems to be a lack of locale support rather than a feature. ISTM that the notation should properly mean "every character that sorts between a and z inclusive". So it's sort order dependent and thus locale dependent --- or at least should be. The locale support in our regexp code is definitely pretty weak at the moment. regards, tom lane