rw_int256

CREATE TABLE table_name (column_name rw_int256);

CREATE TABLE t (v rw_int256);
INSERT INTO t VALUES (1), (100), (10000), (100000000), (10000000000000000), ('100000000000000000000000000000000'), (0), (-1), (-100), (-10000), (-100000000), (-10000000000000000), ('-100000000000000000000000000000000');

cast ('0xfffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffe' AS rw_int256);
-- or
'10000000000000000' :: rw_int256;

count ( [ DISTINCT ] rw_int256 ) -> bigint

SELECT count(v) FROM t;

13

min ( rw_int256 ) -> rw_int256

SELECT min(v) FROM t;

-100000000000000000000000000000000

max ( rw_int256 ) -> rw_int256

SELECT max(v) FROM t;

100000000000000000000000000000000

sum ( [ DISTINCT ] rw_int256 ) -> rw_int256

SELECT sum(v) FROM t;

0

avg ( [ DISTINCT ] rw_int256 ) -> double

SELECT avg(v) FROM t;

0

hex_to_int256 ( string ) -> rw_int256

SELECT hex_to_int256('0xdeadbeef');

3735928559

SELECT hex_to_int256('0xffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff01');

-255

stddev_pop ( rw_int256 ) -> double -- standard deviation
stddev_samp ( rw_int256 ) -> double -- sample standard deviation
var_pop ( rw_int256 ) -> double -- population variance
var_samp ( rw_int256 ) -> double -- sample variance

SELECT stddev_pop(v), stddev_samp(v), var_pop(v), var_samp(v) FROM t;

       stddev_pop       |     stddev_samp      |        var_pop         |        var_samp
------------------------+----------------------+------------------------+------------------------
 3.9223227027636808e+31 | 4.08248290463863e+31 | 1.5384615384615386e+63 | 1.6666666666666666e+63
(1 row)