Re: How I can check a substring is a valid number in postgresql ?

From: Volkan YAZICI <yazicivo(at)ttmail(dot)com>
To: "Anoop G" <anoopmadavoor(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How I can check a substring is a valid number in postgresql ?
Date: 2008-04-24 13:53:15
Message-ID: 87wsmn5ph0.fsf@alamut.mobiliz.com.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, 24 Apr 2008, "Anoop G" <anoopmadavoor(at)gmail(dot)com> writes:
> How I can check a substring is a valid number in postgresql ?

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

Regards.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Colin Wetherbee 2008-04-24 14:15:23 Re: First day of month, last day of month
Previous Message Anoop G 2008-04-24 13:34:50 How I can check a substring is a valid number in postgresql ?