SQL正则判断字符串是不是数字

SQL正则判断字符串是不是数字

test=# select '11.1.1.1' ~ '^(-?\d+)(\.\d+)?$';
 ?column?
----------
 f
(1 row)

test=# select '11.1' ~ '^(-?\d+)(\.\d+)?$';
 ?column?
----------
 t
(1 row)

test=# select '-11.1' ~ '^(-?\d+)(\.\d+)?$';
 ?column?
----------
 t
(1 row)

test=# select '-11.1a' ~ '^(-?\d+)(\.\d+)?$';
 ?column?
----------
 f
(1 row)

test=# select '-11' ~ '^(-?\d+)(\.\d+)?$';
 ?column?
----------
 t
(1 row)

test=#