Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 5F7912E003D for ; Thu, 24 Apr 2008 10:48:28 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 29567-09 for ; Thu, 24 Apr 2008 10:48:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mailserver.ttmail.com (unknown [88.255.235.9]) by developer.postgresql.org (Postfix) with ESMTP id 030D22E0037 for ; Thu, 24 Apr 2008 10:48:20 -0300 (ADT) Received: from SMTP6 ([192.168.19.141]) by mailserver.ttmail.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 24 Apr 2008 16:47:07 +0300 Received: from alamut.mobiliz.com.tr ([213.139.194.86]) by SMTP6 with Microsoft SMTPSVC(6.0.3790.1830); Thu, 24 Apr 2008 16:47:07 +0300 Received: from (unknown [213.139.194.86]) by AVGW-TTMAIL-4.ttmail.com with smtp id 4676_ec325f46_1204_11dd_a923_001422175f2f; Thu, 24 Apr 2008 16:47:06 +0300 From: Volkan YAZICI To: "Anoop G" Cc: pgsql-sql@postgresql.org Subject: Re: How I can check a substring is a valid number in postgresql ? References: <1a027d210804240634w4ee63ccdi251757231d3827bf@mail.gmail.com> Date: Thu, 24 Apr 2008 16:53:15 +0300 In-Reply-To: <1a027d210804240634w4ee63ccdi251757231d3827bf@mail.gmail.com> (Anoop G.'s message of "Thu, 24 Apr 2008 19:04:50 +0530") Message-ID: <87wsmn5ph0.fsf@alamut.mobiliz.com.tr> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.0.60 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-NAI-Spam-Report: 0 Rules triggered X-OriginalArrivalTime: 24 Apr 2008 13:47:07.0574 (UTC) FILETIME=[AFE51560:01C8A611] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/155 X-Sequence-Number: 30694 On Thu, 24 Apr 2008, "Anoop G" writes: > How I can check a substring is a valid number in postgresql ? SELECT col ~ '[0-9]+'; Regards.