Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id F04E66333E5 for ; Wed, 3 Feb 2010 17:54:39 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 19401-04 for ; Wed, 3 Feb 2010 21:54:15 +0000 (UTC) X-Greylist: delayed 00:20:42.292942 by SQLgrey-1.7.6 Received: from proxy2.bredband.net (proxy2.bredband.net [195.54.101.72]) by mail.postgresql.org (Postfix) with ESMTP id 3BC4E63396F for ; Wed, 3 Feb 2010 17:54:29 -0400 (AST) Received: from ipb2.telenor.se (195.54.127.165) by proxy2.bredband.net (7.3.140.3) id 4AD3E1BC02F10F81 for pgsql-sql@postgresql.org; Wed, 3 Feb 2010 22:33:44 +0100 X-SMTPAUTH-B2: X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AkIYAB96aUtT46mEOWdsb2JhbAAImzMBAQEBIBe9J4RGBA X-IronPort-AV: E=Sophos;i="4.49,400,1262559600"; d="scan'208";a="32567745" Received: from ua-83-227-169-132.cust.bredbandsbolaget.se (HELO [192.168.44.43]) ([83.227.169.132]) by ipb2.telenor.se with ESMTP; 03 Feb 2010 22:33:44 +0100 Content-Type: text/plain; charset=windows-1252 Mime-Version: 1.0 (Apple Message framework v1077) Subject: Re: please help me on regular expression From: Lars Gustafsson In-Reply-To: Date: Wed, 3 Feb 2010 22:33:43 +0100 Content-Transfer-Encoding: quoted-printable Message-Id: References: To: pgsql-sql@postgresql.org X-Mailer: Apple Mail (2.1077) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/29 X-Sequence-Number: 33628 Some people, when confronted with a problem, think "I know, I'll use regular expressions." Now they have two problems. =97 Jamie Zawinski 3 feb 2010 kl. 21.32 skrev Tena Sakai: > Thank you, Dirk. >=20 > Regards, >=20 > Tena Sakai > tsakai@gallo.ucsf.edu >=20 >=20 > On 2/3/10 11:43 AM, "Dirk Jagdmann" wrote: >=20 >> Be careful when working with backslashes and regular expressions for >> the proper (double) escaping! >>=20 >> # select '70a5' ~ e'\\d+\.\\d+'; >> ?column? >> ---------- >> t >> (1 row) >>=20 >> # select '70a5' ~ e'\\d+\\.\\d+'; >> ?column? >> ---------- >> f >> (1 row) >>=20 >> # select '70.5' ~ e'\\d+\\.\\d+'; >> ?column? >> ---------- >> t >=20 >=20 > --=20 > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql