Skip site navigation (1) Skip section navigation (2)

Re: Function testing if a string is a number ?

From: Arnaud Lesauvage <thewild(at)freesurf(dot)fr>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Function testing if a string is a number ?
Date: 2006-02-20 15:14:45
Message-ID: 43F9DCE5.8070103@freesurf.fr (view raw or flat)
Thread:
Lists: pgsql-novice
Tom Lane a écrit :
> Arnaud Lesauvage <thewild(at)freesurf(dot)fr> writes:
>> I am searching for a function that would return true if a string 
>> is a number.
>> In Access I would have written IsNumeric('mystring'), but this 
>> function does not exist in postgres.
> 
> Write your own using a pattern test, for instance
> 	varchar ~ '^[0-9]+$'
> See
> http://www.postgresql.org/docs/8.1/static/functions-matching.html

Oh yes ! Regular expressions !
I have to think about it now !!!

Thanks a lot Tom !

Regards
--
Arnaud


In response to

pgsql-novice by date

Next:From: Paolo De SimoneDate: 2006-02-21 09:41:03
Subject: problems to install PostgreSQL
Previous:From: Tom LaneDate: 2006-02-20 15:09:46
Subject: Re: Function testing if a string is a number ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group