?? cidr.out
字號:
-- cidr checkCREATE TABLE cidrtmp AS SELECT cidr(a) AS a FROM inettmp ;SET enable_seqscan=on;SELECT count(*) FROM cidrtmp WHERE a < '121.111.63.82'; count ------- 290(1 row)SELECT count(*) FROM cidrtmp WHERE a <= '121.111.63.82'; count ------- 291(1 row)SELECT count(*) FROM cidrtmp WHERE a = '121.111.63.82'; count ------- 1(1 row)SELECT count(*) FROM cidrtmp WHERE a >= '121.111.63.82'; count ------- 310(1 row)SELECT count(*) FROM cidrtmp WHERE a > '121.111.63.82'; count ------- 309(1 row)CREATE INDEX cidridx ON cidrtmp USING gist ( a );SET enable_seqscan=off;SELECT count(*) FROM cidrtmp WHERE a < '121.111.63.82'::cidr; count ------- 290(1 row)SELECT count(*) FROM cidrtmp WHERE a <= '121.111.63.82'::cidr; count ------- 291(1 row)SELECT count(*) FROM cidrtmp WHERE a = '121.111.63.82'::cidr; count ------- 1(1 row)SELECT count(*) FROM cidrtmp WHERE a >= '121.111.63.82'::cidr; count ------- 310(1 row)SELECT count(*) FROM cidrtmp WHERE a > '121.111.63.82'::cidr; count ------- 309(1 row)?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -