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