From: Venky Kandaswamy <venky@adchemy.com>
To: pgsql-sql <pgsql-sql@postgresql.org>, "emilu@encs.concordia.ca"
 <emilu@encs.concordia.ca>
Subject: Re: isnumeric(varchar) by psql
Thread-Topic: [SQL] isnumeric(varchar) by psql
Thread-Index: AQHO67pGTzV1laxzhUWy5ZnjUSoiXpo5nkrh
Date: Wed, 27 Nov 2013 21:54:22 +0000
Message-ID: 
 <ac3529b8c58344cb803db286743344b7@BY2PR05MB237.namprd05.prod.outlook.com>
References: <52966824.8070404@encs.concordia.ca>
In-Reply-To: <52966824.8070404@encs.concordia.ca>
Accept-Language: en-US
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

Depends on what you want to really do. You can simply cast the field to num=
eric ( col::numeric) and it will convert it - or fail if it cannot.=20
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=
.=20

________________________________________

Venky Kandaswamy

Principal Engineer, Adchemy Inc.

925-200-7124

________________________________________
From: pgsql-sql-owner@postgresql.org <pgsql-sql-owner@postgresql.org> on be=
half 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


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