Hi list !
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.
Maybe I am doing this the wrong way actually : I want to fill an
integer field with the values from a varchard field. Some of the
values are not convertible though, so just executing :
returns an error 'Invalid input syntax for integer "blablabla"'.
My idea was to run :
but maybe there is a better way to achieve this ?
Thanks for your help !
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2006-02-20 15:09:46|
|Subject: Re: Function testing if a string is a number ? |
|Previous:||From: Bruno Wolff III||Date: 2006-02-20 14:12:19|
|Subject: Re: Restoring SQL Databse for use in PostgreSQL.|