BEGIN;
CREATE EXTENSION IF NOT EXISTS anon CASCADE;
NOTICE:  installing required extension "tsm_system_rows"
NOTICE:  installing required extension "pgcrypto"
SELECT anon.init();
 init 
------
 t
(1 row)

--
-- Generic Types
--
-- zip
SELECT pg_typeof(anon.random_zip()) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

-- string
SELECT pg_typeof(anon.random_string(1)) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

-- Date
SELECT pg_typeof(anon.random_date_between('1900-01-01'::TIMESTAMP WITH TIME ZONE,now())) = 'TIMESTAMP WITH TIME ZONE'::REGTYPE;
 ?column? 
----------
 t
(1 row)

SELECT pg_typeof(anon.random_date_between('0001-01-01'::DATE,'4001-01-01'::DATE)) = 'TIMESTAMP WITH TIME ZONE'::REGTYPE;
 ?column? 
----------
 t
(1 row)

SELECT pg_typeof(anon.random_date()) = 'TIMESTAMP WITH TIME ZONE'::REGTYPE;
 ?column? 
----------
 t
(1 row)

-- Integer
SELECT pg_typeof(anon.random_int_between(1,3)) = 'INTEGER'::REGTYPE;
 ?column? 
----------
 t
(1 row)

SELECT ROUND(AVG(anon.random_int_between(1,3))) = 2
FROM generate_series(1,100);
 ?column? 
----------
 t
(1 row)

SELECT pg_typeof(anon.random_bigint_between(1,3)) = 'BIGINT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

SELECT ROUND(AVG(anon.random_bigint_between(2147483648,2147483650))) = 2147483649
FROM generate_series(1,100);
 ?column? 
----------
 t
(1 row)

-- Phone
SELECT pg_typeof(anon.random_phone('0033')) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

SELECT anon.random_phone(NULL) IS NULL;
 ?column? 
----------
 t
(1 row)

SELECT pg_typeof(anon.random_phone()) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

-- Array
SELECT anon.random_in(NULL::DATE[]) IS NULL;
 ?column? 
----------
 t
(1 row)

SELECT avg(anon.random_in(ARRAY[1,2,3]))::INT = 2 FROM generate_series(1,100);
 ?column? 
----------
 t
(1 row)

SELECT pg_typeof(anon.random_in(ARRAY['yes','no','maybe'])) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

DROP EXTENSION anon CASCADE;
ROLLBACK;