Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 42622633A66 for ; Wed, 3 Feb 2010 15:43:21 -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 90498-07 for ; Wed, 3 Feb 2010 19:42:58 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-px0-f186.google.com (mail-px0-f186.google.com [209.85.216.186]) by mail.postgresql.org (Postfix) with ESMTP id 3EE9E633128 for ; Wed, 3 Feb 2010 15:43:10 -0400 (AST) Received: by pxi16 with SMTP id 16so659359pxi.29 for ; Wed, 03 Feb 2010 11:43:08 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=j1UbRdUOImRtaCVLYVZC7hJjZfoz8bbhFRTdzT8XiCo=; b=QnkVZsnp/1X+UzH+s0SPSPimoUJPm2pyADIVxmN/T0rbfMGXId2Hd5Ebyr1F/KQj0P 7Pzf4Qf/8GnFi8uiYSKhc3e3S0mL91ppw1AFFfohHHKhQWE1VM3Wtz64Wj+7gxmaeQT+ QP7E4KLPhRV/ObwlQR52X9Z/wQ570lIRLBCaI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=JailBwEDgBtGh8w+ZrsWs53XQOB/uHQod0cUXvjHaYd0yMz7/EGhyTdviNWI6nl7ey BZPr1UAv/uJyGLFkOtmo2NAHbG3XofiGDXK5O88CjjJIqZuxeuh+BaOGWbDlJXUxL97g LRzd+8XEwkfLMj2eVhubgOZSOB1tkbJtxe0pw= MIME-Version: 1.0 Received: by 10.140.248.13 with SMTP id v13mr53766rvh.1.1265226183157; Wed, 03 Feb 2010 11:43:03 -0800 (PST) In-Reply-To: <162867791002021238j31ad8d7cge44bbce28ff451f3@mail.gmail.com> References: <162867791002021238j31ad8d7cge44bbce28ff451f3@mail.gmail.com> Date: Wed, 3 Feb 2010 11:43:03 -0800 Message-ID: <5d0f60991002031143t404064e6m597dd0eb187cbf62@mail.gmail.com> Subject: Re: please help me on regular expression From: Dirk Jagdmann To: Pavel Stehule Cc: Tena Sakai , "pgsql-sql@postgresql.org" Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.11 tagged_above=-10 required=5 tests=BAYES_05=-1.11 X-Spam-Level: X-Archive-Number: 201002/27 X-Sequence-Number: 33626 Be careful when working with backslashes and regular expressions for the proper (double) escaping! # select '70a5' ~ e'\\d+\.\\d+'; ?column? ---------- t (1 row) # select '70a5' ~ e'\\d+\\.\\d+'; ?column? ---------- f (1 row) # select '70.5' ~ e'\\d+\\.\\d+'; ?column? ---------- t -- ---> Dirk Jagdmann ----> http://cubic.org/~doj -----> http://llg.cubic.org