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 if it can or returns null if not.

________________________________________

Venky Kandaswamy

Principal Engineer, Adchemy Inc.

925-200-7124

________________________________________
From: pgsql-sql-owner(at)postgresql(dot)org <pgsql-sql-owner(at)postgresql(dot)org> on behalf of Emi Lu <emilu(at)encs(dot)concordia(dot)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(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql