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]+$'
Oh yes ! Regular expressions !
I have to think about it now !!!
Thanks a lot Tom !
In response to
pgsql-novice by date
|Next:||From: Paolo De Simone||Date: 2006-02-21 09:41:03|
|Subject: problems to install PostgreSQL|
|Previous:||From: Tom Lane||Date: 2006-02-20 15:09:46|
|Subject: Re: Function testing if a string is a number ? |