isnumeric(varchar) by psql - Mailing list pgsql-sql

From Emi Lu
Subject isnumeric(varchar) by psql
Date
Msg-id 52966824.8070404@encs.concordia.ca
Whole thread Raw
Responses Re: isnumeric(varchar) by psql  (Venky Kandaswamy <venky@adchemy.com>)
List pgsql-sql
Hello,

Does psql provide a function isnumeric(varchar) to check if a varchar 
can be converted to a numeric field?

E.g.,    x     | isnumeric
----------+-----------          | f .        | f .0       | t 0.       | t 0        | t 1        | t 123      | t
123.456 | t abc      | f 1..2     | f 1.2.3.4  | f 1x234    | f 1.234e-5 | t
 

Thanks a lot
Emi
--
Found examples users created by self. If psql provides similar one already?





pgsql-sql by date:

Previous
From: Marcin Krawczyk
Date:
Subject: Re: tab delimiter in output
Next
From: Venky Kandaswamy
Date:
Subject: Re: isnumeric(varchar) by psql