数据仓库服务 GAUSSDB(DWS)-cidr和inet操作符:-

时间:2024-01-26 16:15:21

-

描述:减

示例:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
SELECT inet '192.168.1.43' - 36 AS RESULT;
   result    
-------------
 192.168.1.7
(1 row)
SELECT inet '192.168.1.43' - inet '192.168.1.19' AS RESULT;
 result 
--------
     24
(1 row)
support.huaweicloud.com/sqlreference-820-dws/dws_06_0317.html