From: Venky Kandaswamy <venky@adchemy.com>
To: pgsql-sql <pgsql-sql@postgresql.org>
To: emilu@encs.concordia.ca <emilu@encs.concordia.ca>
Subject: Re: isnumeric(varchar) by psql
Date: Wed, 27 Nov 2013 21:54:22 +0000
Message-ID: <ac3529b8c58344cb803db286743344b7@BY2PR05MB237.namprd05.prod.outlook.com> (raw)
In-Reply-To: <52966824.8070404@encs.concordia.ca>
References: <52966824.8070404@encs.concordia.ca>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
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@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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: venky@adchemy.com, emilu@encs.concordia.ca
Subject: Re: isnumeric(varchar) by psql
In-Reply-To: <ac3529b8c58344cb803db286743344b7@BY2PR05MB237.namprd05.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox