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 447B2D6F06 for ; Mon, 5 Sep 2005 12:47:48 -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 33727-01 for ; Mon, 5 Sep 2005 15:47:45 +0000 (GMT) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by svr1.postgresql.org (Postfix) with ESMTP id D3483D6F1A for ; Mon, 5 Sep 2005 12:47:43 -0300 (ADT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1ECJ9I-0006wo-3z for pgsql-sql@postgresql.org; Mon, 05 Sep 2005 17:44:44 +0200 Received: from srv.protecting.net ([212.126.218.242]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 05 Sep 2005 17:44:44 +0200 Received: from hf0614x by srv.protecting.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 05 Sep 2005 17:44:44 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-sql@postgresql.org From: Harald Fuchs Subject: Re: POSIX Regular Expression question Date: 05 Sep 2005 17:40:37 +0200 Organization: Linux Private Site Lines: 14 Message-ID: <87k6hv7cay.fsf@srv.protecting.net> References: <431C4EB2.80401@mediaroot.de> <200509051619.29210.peter_e@gmx.net> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: srv.protecting.net User-Agent: Gnus/5.0808 (Gnus v5.8.8) Emacs/20.7 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.09 required=5 tests=[AWL=0.090] X-Spam-Level: X-Archive-Number: 200509/37 X-Sequence-Number: 22584 In article <200509051619.29210.peter_e@gmx.net>, Peter Eisentraut writes: > Presumably, > colname ~ '^[A-Za-z]*$' > If you want to be independent of locale issues, then you'd have to enumerate > all the letters instead of using a range specification. How so? I thought character ranges are more an encoding than a locale issue. I dunno the details of the supported encodings, but is there any encoding where 'a-z' includes more or less than 26 letters? Fortunately we don't support EBCDIC ;-)