create schema db_conv;
set current_schema to 'db_conv';
select conv('a',16,2);
conv
------
1010
(1 row)
select conv('6e',18,8);
conv
------
172
(1 row)
select conv(-17,10,-18);
conv
------
-H
(1 row)
select conv('10'+10,16,10);
conv
------
32
(1 row)
select conv('ffffffffffffffff',16,10);
conv
----------------------
18446744073709551615
(1 row)
select conv('ffffffffffffffff',16,-10);
conv
------
-1
(1 row)
select conv('-ffffffffffffffff',16,10);
conv
------
1
(1 row)
select conv('-ffffffffffffffff',16,-10);
conv
------
1
(1 row)
select conv('ffffffffffffffff1',16,10);
conv
----------------------
18446744073709551615
(1 row)
select conv('ffffffffffffffff1',16,-10);
conv
------
-1
(1 row)
select conv('-ffffffffffffffff1',16,10);
conv
----------------------
18446744073709551615
(1 row)
select conv('-ffffffffffffffff1',16,-10);
conv
------
-1
(1 row)
select conv('',16,16);
conv
------
(1 row)
select conv(5,4,10);
conv
------
0
(1 row)
select conv(1234,5,10);
conv
------
194
(1 row)
select conv(-9223372036854775809,-10,16);
conv
------------------
8000000000000000
(1 row)
select conv('8000000000000000',16,16);
conv
------------------
8000000000000000
(1 row)
select conv(9223372036854775807,10,16);
conv
------------------
7FFFFFFFFFFFFFFF
(1 row)
select conv(-9223372036854775808,10,16);
conv
------------------
8000000000000000
(1 row)
select conv(9223372036854775807,-10,16);
conv
------------------
7FFFFFFFFFFFFFFF
(1 row)
select conv(-9223372036854775808,-10,16);
conv
------------------
8000000000000000
(1 row)
select conv(9223372036854775807,-10,-16);
conv
------------------
7FFFFFFFFFFFFFFF
(1 row)
select conv(-9223372036854775808,-10,-16);
conv
-------------------
-8000000000000000
(1 row)
select conv(9223372036854775807,10,-16);
conv
------------------
7FFFFFFFFFFFFFFF
(1 row)
select conv(-9223372036854775808,10,-16);
conv
-------------------
-8000000000000000
(1 row)
select conv(15632,16,36);
conv
------
1VLE
(1 row)
select conv(-15632,16,32);
conv
---------------
FVVVVVVVVTAEE
(1 row)
select conv(15632,-16,32);
conv
------
2LHI
(1 row)
select conv(-15632,-16,32);
conv
---------------
FVVVVVVVVTAEE
(1 row)
select conv(15632,-16,-32);
conv
------
2LHI
(1 row)
select conv(-15632,-16,-32);
conv
-------
-2LHI
(1 row)
select conv(15632,16,-32);
conv
------
2LHI
(1 row)
select conv(-15632,16,-32);
conv
-------
-2LHI
(1 row)
select conv('ffffffffffffffff',16,16);
conv
------------------
FFFFFFFFFFFFFFFF
(1 row)
select conv('ffffffffffffffff',16,-16);
conv
------
-1
(1 row)
select conv('ffffffffffffffff',-16,16);
conv
------------------
7FFFFFFFFFFFFFFF
(1 row)
select conv('ffffffffffffffff',-16,-16);
conv
------------------
7FFFFFFFFFFFFFFF
(1 row)
select conv('-ffffffffffffffff',16,16);
conv
------
1
(1 row)
select conv('-ffffffffffffffff',16,-16);
conv
------
1
(1 row)
select conv('-ffffffffffffffff',-16,16);
conv
------------------
8000000000000000
(1 row)
select conv('-ffffffffffffffff',-16,-16);
conv
-------------------
-8000000000000000
(1 row)
select conv('1ffffffffffffffff',16,16);
conv
------------------
FFFFFFFFFFFFFFFF
(1 row)
select conv('1ffffffffffffffff',16,-16);
conv
------
-1
(1 row)
select conv('1ffffffffffffffff',-16,16);
conv
------------------
7FFFFFFFFFFFFFFF
(1 row)
select conv('1ffffffffffffffff',-16,-16);
conv
------------------
7FFFFFFFFFFFFFFF
(1 row)
select conv('-1ffffffffffffffff',16,16);
conv
------------------
FFFFFFFFFFFFFFFF
(1 row)
select conv('-1ffffffffffffffff',16,-16);
conv
------
-1
(1 row)
select conv('-1ffffffffffffffff',-16,16);
conv
------------------
8000000000000000
(1 row)
select conv('-1ffffffffffffffff',-16,-16);
conv
-------------------
-8000000000000000
(1 row)
select conv('8000000000000000',16,16);
conv
------------------
8000000000000000
(1 row)
select conv('8000000000000000',16,-16);
conv
-------------------
-8000000000000000
(1 row)
select conv('8000000000000000',-16,16);
conv
------------------
7FFFFFFFFFFFFFFF
(1 row)
select conv('8000000000000000',-16,-16);
conv
------------------
7FFFFFFFFFFFFFFF
(1 row)
select conv('-8000000000000000',16,16);
conv
------------------
8000000000000000
(1 row)
select conv('-8000000000000000',16,-16);
conv
-------------------
-8000000000000000
(1 row)
select conv('-8000000000000000',-16,16);
conv
------------------
8000000000000000
(1 row)
select conv('-8000000000000000',-16,-16);
conv
-------------------
-8000000000000000
(1 row)
select conv('1',16,16);
conv
------
1
(1 row)
select conv('1',16,-16);
conv
------
1
(1 row)
select conv('1',-16,16);
conv
------
1
(1 row)
select conv('1',-16,-16);
conv
------
1
(1 row)
select conv('-1',16,16);
conv
------------------
FFFFFFFFFFFFFFFF
(1 row)
select conv('-1',16,-16);
conv
------
-1
(1 row)
select conv('-1',-16,16);
conv
------------------
FFFFFFFFFFFFFFFF
(1 row)
select conv('-1',-16,-16),conv(0,10,10);
conv | conv
------+------
-1 | 0
(1 row)
select conv('null',10,2),conv('a57b',11,35),conv('null',30,20);
conv | conv | conv
------+------+------
0 | 11C | 13
(1 row)
select conv(95446461559756285324284,18,10),conv(6.69488535e+25,26,17),conv(12345678965412314567,10,16);
conv | conv | conv
----------------------+------------------+------------------
18446744073709551615 | 67979G60F5428010 | AB54A99BDC69BDC7
(1 row)
select conv('张三',26,17),conv('pxy',16,10),conv(256,2,16),conv(973,8,15);
conv | conv | conv | conv
------+------+------+------
0 | 0 | 0 | 0
(1 row)
select conv('%',26,17),conv('$',31,19),conv('?',10,16);
conv | conv | conv
------+------+------
0 | 0 | 0
(1 row)
select conv(10,1,27),conv('zzzz',0,5),conv('xy57',37,8),conv(10,-1,27),conv('xy57',-37,8);
conv | conv | conv | conv | conv
------+------+------+------+------
| | | |
(1 row)
select conv(10,1/2,23),conv(10,1.333,23),conv('xy57',pi(),8),conv(10,'Asc',27),conv(321,'',8),conv(321,'张三',8);
WARNING: invalid input syntax for type integer: "Asc"
LINE 1: ...23),conv(10,1.333,23),conv('xy57',pi(),8),conv(10,'Asc',27),...
^
CONTEXT: referenced column: conv
WARNING: invalid input syntax for type integer: ""
LINE 1: ...3),conv('xy57',pi(),8),conv(10,'Asc',27),conv(321,'',8),conv...
^
CONTEXT: referenced column: conv
WARNING: invalid input syntax for type integer: "张三"
LINE 1: ...pi(),8),conv(10,'Asc',27),conv(321,'',8),conv(321,'张三',8);
^
CONTEXT: referenced column: conv
conv | conv | conv | conv | conv | conv
------+------+------+------+------+------
| | 0 | | |
(1 row)
select conv(10,27,1/2),conv(10,16,'AscY'),conv(321,7,''),conv(321,10,'张三');
WARNING: invalid input syntax for type integer: "AscY"
LINE 1: select conv(10,27,1/2),conv(10,16,'AscY'),conv(321,7,''),con...
^
CONTEXT: referenced column: conv
WARNING: invalid input syntax for type integer: ""
LINE 1: ...ect conv(10,27,1/2),conv(10,16,'AscY'),conv(321,7,''),conv(3...
^
CONTEXT: referenced column: conv
WARNING: invalid input syntax for type integer: "张三"
LINE 1: ...,1/2),conv(10,16,'AscY'),conv(321,7,''),conv(321,10,'张三');
^
CONTEXT: referenced column: conv
conv | conv | conv | conv
------+------+------+------
| | |
(1 row)
select conv(10,27,1),conv('zzzz',0,0),conv('xy57',-8,37);
conv | conv | conv
------+------+------
| |
(1 row)
select conv(558,8,8),conv(121,2,10),conv(678,7,10),conv(789,8,10),conv('22G',16,10);
conv | conv | conv | conv | conv
------+------+------+------+------
55 | 1 | 6 | 7 | 34
(1 row)
select conv(818,8,8),conv(310,2,10),conv(999,7,10),conv(888,8,10),conv('GHT',16,10),conv(3,-3,8);
conv | conv | conv | conv | conv | conv
------+------+------+------+------+------
0 | 0 | 0 | 0 | 0 | 0
(1 row)
select conv(1.5,10,10),conv(1.4,10,10);
conv | conv
------+------
1 | 1
(1 row)
select conv(9544646155975628532428411,10,10);
conv
----------------------
18446744073709551615
(1 row)
select conv(9544646155975628532428411,10,-10);
conv
------
-1
(1 row)
select conv(9544646155975628532428411,-10,10);
conv
---------------------
9223372036854775807
(1 row)
select conv(9544646155975628532428411,-10,-10);
conv
---------------------
9223372036854775807
(1 row)
select conv(-9544646155975628532428411,10,10);
conv
----------------------
18446744073709551615
(1 row)
select conv(-9544646155975628532428411,10,-10);
conv
------
-1
(1 row)
select conv(-9544646155975628532428411,-10,10);
conv
---------------------
9223372036854775808
(1 row)
select conv(-9544646155975628532428411,-10,-10);
conv
----------------------
-9223372036854775808
(1 row)
drop schema db_conv cascade;
reset current_schema;