Postgres Pro
Downloads
Home   >   mailing lists

Re: How I can check a substring is a valid number in postgresql ? - Mailing list pgsql-sql

From Volkan YAZICI
Subject Re: How I can check a substring is a valid number in postgresql ?
Date
Msg-id 87wsmn5ph0.fsf@alamut.mobiliz.com.tr
Whole thread Raw
In response to How I can check a substring is a valid number in postgresql ?  ("Anoop G" <anoopmadavoor@gmail.com>)
List pgsql-sql
Tree view 
On Thu, 24 Apr 2008, "Anoop G" <anoopmadavoor@gmail.com> writes:
> How I can check a substring is a valid number in postgresql ?

SELECT col ~ '[0-9]+';


Regards.

pgsql-sql by date:

Previous
From: "Anoop G"
Date:
Subject: How I can check a substring is a valid number in postgresql ?
Next
From: Colin Wetherbee
Date:
Subject: Re: First day of month, last day of month