Re: isnumeric(varchar) by psql

Depends on what you want to really do. You can simply cast the field to numeric ( col::numeric) and it will convert it
-or fail if it cannot.  
On the other hand, if you do not want it to fail on non-numeric data, then just write a simple function that converts
ifit can or returns null if not.  

________________________________________

Venky Kandaswamy

Principal Engineer, Adchemy Inc.

925-200-7124

________________________________________
From: pgsql-sql-owner@postgresql.org <pgsql-sql-owner@postgresql.org> on behalf of Emi Lu <emilu@encs.concordia.ca>
Sent: Wednesday, November 27, 2013 1:46 PM
To: pgsql-sql
Subject: [SQL] isnumeric(varchar) by psql

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?




--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql