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 3437DD732B for ; Mon, 5 Sep 2005 10:57:11 -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 99711-08 for ; Mon, 5 Sep 2005 13:57:05 +0000 (GMT) Received: from 217-20-115-93.internetserviceteam.com (217-20-115-93.internetserviceteam.com [217.20.115.93]) by svr1.postgresql.org (Postfix) with ESMTP id 3F3FDD6D7B for ; Mon, 5 Sep 2005 10:57:06 -0300 (ADT) Received: from [192.168.1.121] (150.Red-83-34-35.pooles.rima-tde.net [83.34.35.150]) by 217-20-115-93.internetserviceteam.com (Postfix) with ESMTP id 9DBDB39743 for ; Mon, 5 Sep 2005 15:09:49 +0200 (CEST) Message-ID: <431C4EB2.80401@mediaroot.de> Date: Mon, 05 Sep 2005 14:57:06 +0100 From: Aldor User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: POSIX Regular Expression question Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200509/30 X-Sequence-Number: 22577 Hi, I want to get out a string only with characters A-Za-z. I tried really a lot of things with substring and read many POSIX docs, I'm also familiar with the Perl RegEx but right now, I'm giving up... ;-( Any idea how to do this in Postgres with POSIX Regex? Regards, Aldor