create schema db_bin;
set current_schema to 'db_bin';
select bin(1);
bin
-----
1
(1 row)
select bin(0);
bin
-----
0
(1 row)
select bin('2');
bin
-----
10
(1 row)
select bin('a');
bin
-----
0
(1 row)
select bin('11a');
bin
------
1011
(1 row)
select bin(1.1);
bin
-----
1
(1 row)
select bin(null);
bin
-----
(1 row)
select bin(true);
bin
-----
1
(1 row)
select bin(false);
bin
-----
0
(1 row)
select bin('测试');
bin
-----
0
(1 row)
-- 测试小数、分数
SELECT BIN('9.2');
bin
------
1001
(1 row)
SELECT BIN('9.6');
bin
------
1001
(1 row)
SELECT BIN('-9.2');
bin
-----
0
(1 row)
SELECT BIN('-9.6');
bin
-----
0
(1 row)
-- 测试特殊符号
SELECT BIN('+19.6');
bin
-----
0
(1 row)
SELECT BIN('a9');
bin
-----
0
(1 row)
SELECT BIN('!9');
bin
-----
0
(1 row)
SELECT BIN('@#9');
bin
-----
0
(1 row)
SELECT BIN(9.2);
bin
------
1001
(1 row)
SELECT BIN(9.6);
bin
------
1001
(1 row)
SELECT BIN(-9.2);
bin
------------------------------------------------------------------
1111111111111111111111111111111111111111111111111111111111110111
(1 row)
SELECT BIN(-9.6);
bin
------------------------------------------------------------------
1111111111111111111111111111111111111111111111111111111111110111
(1 row)
select BIN(-13/4);
bin
------------------------------------------------------------------
1111111111111111111111111111111111111111111111111111111111111101
(1 row)
-- 测试bit类型,b''默认为bit类型
select bin(b'101');
bin
-----
101
(1 row)
select bin(b'0001101');
bin
------
1101
(1 row)
select bin(b'0000000');
bin
-----
0
(1 row)
drop schema db_bin cascade;
reset current_schema;