postgresql isnumeric

发布时间：2020-12-13 17:25:42 所属栏目：百科来源：网络整理

导读：WITH test(x) AS ( VALUES (''),('.'),('.0'),('0.'),('0'),('1'),('123'),('123.456'),('abc'),('1..2'),('1.2.3.4'),('1x234'),('1.234e-5')) SELECT x,x ~ '^([0-9]+[.]?[0-9]*|[.][0-9]+)$' AS isnumericFROM test; WITH test(x) AS ( VALUES (''),('1.2

WITH test(x) AS (
 VALUES (''),('.'),('.0'),('0.'),('0'),('1'),('123'),('123.456'),('abc'),('1..2'),('1.2.3.4'),('1x234'),('1.234e-5'))
SELECT x,x ~ '^([0-9]+[.]?[0-9]*|[.][0-9]+)$' AS isnumeric
FROM test;
WITH test(x) AS ( VALUES (''),('1.2.3.4')) SELECT x,x ~ '^[0-9]*.?[0-9]*$' AS isnumeric FROM test;------下面才是正解

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!