set dolphin.use_const_value_as_colname=false;
create schema union_all;
set current_schema to 'union_all';

CREATE TYPE rainbow AS ENUM ('red', 'orange', 'yellow', 'green', 'blue', 'purple');

select 1 union all select '';
select 1 union all select ' ';
select 'a' union all select 1;
select b'1' union all select '';
select b'1' union all select ' ';

select null::int1 union all select null::int16;
select null::int1 union all select null::record;
select null::int1 union all select null::cstring;
select null::int1 union all select null::anyarray;
select null::int1 union all select null::void;
select null::int1 union all select null::anyelement;
select null::int1 union all select null::anynonarray;
select null::int1 union all select 'red'::rainbow::anyenum;
select null::int1 union all select null::anyrange;
select null::int1 union all select null::hll_hashval;
select null::int1 union all select null::hll_trans_type;
select null::int1 union all select null::byteawithoutorderwithequalcol;
select null::int1 union all select null::byteawithoutordercol;
select null::int1 union all select null::anyset;

select null::int2 union all select null::int16;
select null::int2 union all select null::record;
select null::int2 union all select null::cstring;
select null::int2 union all select null::anyarray;
select null::int2 union all select null::void;
select null::int2 union all select null::anyelement;
select null::int2 union all select null::anynonarray;
select null::int2 union all select 'red'::rainbow::anyenum;
select null::int2 union all select null::anyrange;
select null::int2 union all select null::hll_hashval;
select null::int2 union all select null::hll_trans_type;
select null::int2 union all select null::byteawithoutorderwithequalcol;
select null::int2 union all select null::byteawithoutordercol;
select null::int2 union all select null::anyset;

select null::int4 union all select null::int16;
select null::int4 union all select null::record;
select null::int4 union all select null::cstring;
select null::int4 union all select null::anyarray;
select null::int4 union all select null::void;
select null::int4 union all select null::anyelement;
select null::int4 union all select null::anynonarray;
select null::int4 union all select 'red'::rainbow::anyenum;
select null::int4 union all select null::anyrange;
select null::int4 union all select null::hll_hashval;
select null::int4 union all select null::hll_trans_type;
select null::int4 union all select null::byteawithoutorderwithequalcol;
select null::int4 union all select null::byteawithoutordercol;
select null::int4 union all select null::anyset;

select null::int8 union all select null::int16;
select null::int8 union all select null::record;
select null::int8 union all select null::cstring;
select null::int8 union all select null::anyarray;
select null::int8 union all select null::void;
select null::int8 union all select null::anyelement;
select null::int8 union all select null::anynonarray;
select null::int8 union all select 'red'::rainbow::anyenum;
select null::int8 union all select null::anyrange;
select null::int8 union all select null::hll_hashval;
select null::int8 union all select null::hll_trans_type;
select null::int8 union all select null::byteawithoutorderwithequalcol;
select null::int8 union all select null::byteawithoutordercol;
select null::int8 union all select null::anyset;

select null::bool union all select null::int16;
select null::bool union all select null::record;
select null::bool union all select null::cstring;
select null::bool union all select null::anyarray;
select null::bool union all select null::void;
select null::bool union all select null::anyelement;
select null::bool union all select null::anynonarray;
select null::bool union all select 'red'::rainbow::anyenum;
select null::bool union all select null::anyrange;
select null::bool union all select null::hll_hashval;
select null::bool union all select null::hll_trans_type;
select null::bool union all select null::byteawithoutorderwithequalcol;
select null::bool union all select null::byteawithoutordercol;
select null::bool union all select null::anyset;

select null::bytea union all select null::int16;
select null::bytea union all select null::record;
select null::bytea union all select null::cstring;
select null::bytea union all select null::anyarray;
select null::bytea union all select null::void;
select null::bytea union all select null::anyelement;
select null::bytea union all select null::anynonarray;
select null::bytea union all select 'red'::rainbow::anyenum;
select null::bytea union all select null::anyrange;
select null::bytea union all select null::hll_hashval;
select null::bytea union all select null::hll_trans_type;
select null::bytea union all select null::byteawithoutorderwithequalcol;
select null::bytea union all select null::byteawithoutordercol;
select null::bytea union all select null::anyset;

select null::char union all select null::int16;
select null::char union all select null::record;
select null::char union all select null::cstring;
select null::char union all select null::anyarray;
select null::char union all select null::void;
select null::char union all select null::anyelement;
select null::char union all select null::anynonarray;
select null::char union all select 'red'::rainbow::anyenum;
select null::char union all select null::anyrange;
select null::char union all select null::hll_hashval;
select null::char union all select null::hll_trans_type;
select null::char union all select null::byteawithoutorderwithequalcol;
select null::char union all select null::byteawithoutordercol;
select null::char union all select null::anyset;

select null::name union all select null::int16;
select null::name union all select null::record;
select null::name union all select null::cstring;
select null::name union all select null::anyarray;
select null::name union all select null::void;
select null::name union all select null::anyelement;
select null::name union all select null::anynonarray;
select null::name union all select 'red'::rainbow::anyenum;
select null::name union all select null::anyrange;
select null::name union all select null::hll_hashval;
select null::name union all select null::hll_trans_type;
select null::name union all select null::byteawithoutorderwithequalcol;
select null::name union all select null::byteawithoutordercol;
select null::name union all select null::anyset;

select null::numeric union all select null::int16;
select null::numeric union all select null::record;
select null::numeric union all select null::cstring;
select null::numeric union all select null::anyarray;
select null::numeric union all select null::void;
select null::numeric union all select null::anyelement;
select null::numeric union all select null::anynonarray;
select null::numeric union all select 'red'::rainbow::anyenum;
select null::numeric union all select null::anyrange;
select null::numeric union all select null::hll_hashval;
select null::numeric union all select null::hll_trans_type;
select null::numeric union all select null::byteawithoutorderwithequalcol;
select null::numeric union all select null::byteawithoutordercol;
select null::numeric union all select null::anyset;

select null::text union all select null::int16;
select null::text union all select null::record;
select null::text union all select null::cstring;
select null::text union all select null::anyarray;
select null::text union all select null::void;
select null::text union all select null::anyelement;
select null::text union all select null::anynonarray;
select null::text union all select 'red'::rainbow::anyenum;
select null::text union all select null::anyrange;
select null::text union all select null::hll_hashval;
select null::text union all select null::hll_trans_type;
select null::text union all select null::byteawithoutorderwithequalcol;
select null::text union all select null::byteawithoutordercol;
select null::text union all select null::anyset;

select null::raw union all select null::int16;
select null::raw union all select null::record;
select null::raw union all select null::cstring;
select null::raw union all select null::anyarray;
select null::raw union all select null::void;
select null::raw union all select null::anyelement;
select null::raw union all select null::anynonarray;
select null::raw union all select 'red'::rainbow::anyenum;
select null::raw union all select null::anyrange;
select null::raw union all select null::hll_hashval;
select null::raw union all select null::hll_trans_type;
select null::raw union all select null::byteawithoutorderwithequalcol;
select null::raw union all select null::byteawithoutordercol;
select null::raw union all select null::anyset;


select null::blob union all select null::int16;
select null::blob union all select null::record;
select null::blob union all select null::cstring;
select null::blob union all select null::anyarray;
select null::blob union all select null::void;
select null::blob union all select null::anyelement;
select null::blob union all select null::anynonarray;
select null::blob union all select 'red'::rainbow::anyenum;
select null::blob union all select null::anyrange;
select null::blob union all select null::hll_hashval;
select null::blob union all select null::hll_trans_type;
select null::blob union all select null::byteawithoutorderwithequalcol;
select null::blob union all select null::byteawithoutordercol;
select null::blob union all select null::anyset;

select null::clob union all select null::int16;
select null::clob union all select null::record;
select null::clob union all select null::cstring;
select null::clob union all select null::anyarray;
select null::clob union all select null::void;
select null::clob union all select null::anyelement;
select null::clob union all select null::anynonarray;
select null::clob union all select 'red'::rainbow::anyenum;
select null::clob union all select null::anyrange;
select null::clob union all select null::hll_hashval;
select null::clob union all select null::hll_trans_type;
select null::clob union all select null::byteawithoutorderwithequalcol;
select null::clob union all select null::byteawithoutordercol;
select null::clob union all select null::anyset;

select null::json union all select null::int16;
select null::json union all select null::record;
select null::json union all select null::cstring;
select null::json union all select null::anyarray;
select null::json union all select null::void;
select null::json union all select null::anyelement;
select null::json union all select null::anynonarray;
select null::json union all select 'red'::rainbow::anyenum;
select null::json union all select null::anyrange;
select null::json union all select null::hll_hashval;
select null::json union all select null::hll_trans_type;
select null::json union all select null::byteawithoutorderwithequalcol;
select null::json union all select null::byteawithoutordercol;
select null::json union all select null::anyset;

select null::jsonb union all select null::int16;
select null::jsonb union all select null::record;
select null::jsonb union all select null::cstring;
select null::jsonb union all select null::anyarray;
select null::jsonb union all select null::void;
select null::jsonb union all select null::anyelement;
select null::jsonb union all select null::anynonarray;
select null::jsonb union all select 'red'::rainbow::anyenum;
select null::jsonb union all select null::anyrange;
select null::jsonb union all select null::hll_hashval;
select null::jsonb union all select null::hll_trans_type;
select null::jsonb union all select null::byteawithoutorderwithequalcol;
select null::jsonb union all select null::byteawithoutordercol;
select null::jsonb union all select null::anyset;

select null::point union all select null::int16;
select null::point union all select null::record;
select null::point union all select null::cstring;
select null::point union all select null::anyarray;
select null::point union all select null::void;
select null::point union all select null::anyelement;
select null::point union all select null::anynonarray;
select null::point union all select 'red'::rainbow::anyenum;
select null::point union all select null::anyrange;
select null::point union all select null::hll_hashval;
select null::point union all select null::hll_trans_type;
select null::point union all select null::byteawithoutorderwithequalcol;
select null::point union all select null::byteawithoutordercol;
select null::point union all select null::anyset;

select null::lseg union all select null::int16;
select null::lseg union all select null::record;
select null::lseg union all select null::cstring;
select null::lseg union all select null::anyarray;
select null::lseg union all select null::void;
select null::lseg union all select null::anyelement;
select null::lseg union all select null::anynonarray;
select null::lseg union all select 'red'::rainbow::anyenum;
select null::lseg union all select null::anyrange;
select null::lseg union all select null::hll_hashval;
select null::lseg union all select null::hll_trans_type;
select null::lseg union all select null::byteawithoutorderwithequalcol;
select null::lseg union all select null::byteawithoutordercol;
select null::lseg union all select null::anyset;

select null::path union all select null::int16;
select null::path union all select null::record;
select null::path union all select null::cstring;
select null::path union all select null::anyarray;
select null::path union all select null::void;
select null::path union all select null::anyelement;
select null::path union all select null::anynonarray;
select null::path union all select 'red'::rainbow::anyenum;
select null::path union all select null::anyrange;
select null::path union all select null::hll_hashval;
select null::path union all select null::hll_trans_type;
select null::path union all select null::byteawithoutorderwithequalcol;
select null::path union all select null::byteawithoutordercol;
select null::path union all select null::anyset;

select null::box union all select null::int16;
select null::box union all select null::record;
select null::box union all select null::cstring;
select null::box union all select null::anyarray;
select null::box union all select null::void;
select null::box union all select null::anyelement;
select null::box union all select null::anynonarray;
select null::box union all select 'red'::rainbow::anyenum;
select null::box union all select null::anyrange;
select null::box union all select null::hll_hashval;
select null::box union all select null::hll_trans_type;
select null::box union all select null::byteawithoutorderwithequalcol;
select null::box union all select null::byteawithoutordercol;
select null::box union all select null::anyset;

select null::polygon union all select null::int16;
select null::polygon union all select null::record;
select null::polygon union all select null::cstring;
select null::polygon union all select null::anyarray;
select null::polygon union all select null::void;
select null::polygon union all select null::anyelement;
select null::polygon union all select null::anynonarray;
select null::polygon union all select 'red'::rainbow::anyenum;
select null::polygon union all select null::anyrange;
select null::polygon union all select null::hll_hashval;
select null::polygon union all select null::hll_trans_type;
select null::polygon union all select null::byteawithoutorderwithequalcol;
select null::polygon union all select null::byteawithoutordercol;
select null::polygon union all select null::anyset;

select null::hash16 union all select null::int16;
select null::hash16 union all select null::record;
select null::hash16 union all select null::cstring;
select null::hash16 union all select null::anyarray;
select null::hash16 union all select null::void;
select null::hash16 union all select null::anyelement;
select null::hash16 union all select null::anynonarray;
select null::hash16 union all select 'red'::rainbow::anyenum;
select null::hash16 union all select null::anyrange;
select null::hash16 union all select null::hll_hashval;
select null::hash16 union all select null::hll_trans_type;
select null::hash16 union all select null::byteawithoutorderwithequalcol;
select null::hash16 union all select null::byteawithoutordercol;
select null::hash16 union all select null::anyset;

select null::smalldatetime union all select null::int16;
select null::smalldatetime union all select null::record;
select null::smalldatetime union all select null::cstring;
select null::smalldatetime union all select null::anyarray;
select null::smalldatetime union all select null::void;
select null::smalldatetime union all select null::anyelement;
select null::smalldatetime union all select null::anynonarray;
select null::smalldatetime union all select 'red'::rainbow::anyenum;
select null::smalldatetime union all select null::anyrange;
select null::smalldatetime union all select null::hll_hashval;
select null::smalldatetime union all select null::hll_trans_type;
select null::smalldatetime union all select null::byteawithoutorderwithequalcol;
select null::smalldatetime union all select null::byteawithoutordercol;
select null::smalldatetime union all select null::anyset;

select null::abstime union all select null::int16;
select null::abstime union all select null::record;
select null::abstime union all select null::cstring;
select null::abstime union all select null::anyarray;
select null::abstime union all select null::void;
select null::abstime union all select null::anyelement;
select null::abstime union all select null::anynonarray;
select null::abstime union all select 'red'::rainbow::anyenum;
select null::abstime union all select null::anyrange;
select null::abstime union all select null::hll_hashval;
select null::abstime union all select null::hll_trans_type;
select null::abstime union all select null::byteawithoutorderwithequalcol;
select null::abstime union all select null::byteawithoutordercol;
select null::abstime union all select null::anyset;

select null::reltime union all select null::int16;
select null::reltime union all select null::record;
select null::reltime union all select null::cstring;
select null::reltime union all select null::anyarray;
select null::reltime union all select null::void;
select null::reltime union all select null::anyelement;
select null::reltime union all select null::anynonarray;
select null::reltime union all select 'red'::rainbow::anyenum;
select null::reltime union all select null::anyrange;
select null::reltime union all select null::hll_hashval;
select null::reltime union all select null::hll_trans_type;
select null::reltime union all select null::byteawithoutorderwithequalcol;
select null::reltime union all select null::byteawithoutordercol;
select null::reltime union all select null::anyset;

select null::tinterval union all select null::int16;
select null::tinterval union all select null::record;
select null::tinterval union all select null::cstring;
select null::tinterval union all select null::anyarray;
select null::tinterval union all select null::void;
select null::tinterval union all select null::anyelement;
select null::tinterval union all select null::anynonarray;
select null::tinterval union all select 'red'::rainbow::anyenum;
select null::tinterval union all select null::anyrange;
select null::tinterval union all select null::hll_hashval;
select null::tinterval union all select null::hll_trans_type;
select null::tinterval union all select null::byteawithoutorderwithequalcol;
select null::tinterval union all select null::byteawithoutordercol;
select null::tinterval union all select null::anyset;

select null::circle union all select null::int16;
select null::circle union all select null::record;
select null::circle union all select null::cstring;
select null::circle union all select null::anyarray;
select null::circle union all select null::void;
select null::circle union all select null::anyelement;
select null::circle union all select null::anynonarray;
select null::circle union all select 'red'::rainbow::anyenum;
select null::circle union all select null::anyrange;
select null::circle union all select null::hll_hashval;
select null::circle union all select null::hll_trans_type;
select null::circle union all select null::byteawithoutorderwithequalcol;
select null::circle union all select null::byteawithoutordercol;
select null::circle union all select null::anyset;


select null::money union all select null::int16;
select null::money union all select null::record;
select null::money union all select null::cstring;
select null::money union all select null::anyarray;
select null::money union all select null::void;
select null::money union all select null::anyelement;
select null::money union all select null::anynonarray;
select null::money union all select 'red'::rainbow::anyenum;
select null::money union all select null::anyrange;
select null::money union all select null::hll_hashval;
select null::money union all select null::hll_trans_type;
select null::money union all select null::byteawithoutorderwithequalcol;
select null::money union all select null::byteawithoutordercol;
select null::money union all select null::anyset;

select null::bpchar union all select null::int16;
select null::bpchar union all select null::record;
select null::bpchar union all select null::cstring;
select null::bpchar union all select null::anyarray;
select null::bpchar union all select null::void;
select null::bpchar union all select null::anyelement;
select null::bpchar union all select null::anynonarray;
select null::bpchar union all select 'red'::rainbow::anyenum;
select null::bpchar union all select null::anyrange;
select null::bpchar union all select null::hll_hashval;
select null::bpchar union all select null::hll_trans_type;
select null::bpchar union all select null::byteawithoutorderwithequalcol;
select null::bpchar union all select null::byteawithoutordercol;
select null::bpchar union all select null::anyset;

select null::varchar union all select null::int16;
select null::varchar union all select null::record;
select null::varchar union all select null::cstring;
select null::varchar union all select null::anyarray;
select null::varchar union all select null::void;
select null::varchar union all select null::anyelement;
select null::varchar union all select null::anynonarray;
select null::varchar union all select 'red'::rainbow::anyenum;
select null::varchar union all select null::anyrange;
select null::varchar union all select null::hll_hashval;
select null::varchar union all select null::hll_trans_type;
select null::varchar union all select null::byteawithoutorderwithequalcol;
select null::varchar union all select null::byteawithoutordercol;
select null::varchar union all select null::anyset;

select null::nvarchar2 union all select null::int16;
select null::nvarchar2 union all select null::record;
select null::nvarchar2 union all select null::cstring;
select null::nvarchar2 union all select null::anyarray;
select null::nvarchar2 union all select null::void;
select null::nvarchar2 union all select null::anyelement;
select null::nvarchar2 union all select null::anynonarray;
select null::nvarchar2 union all select 'red'::rainbow::anyenum;
select null::nvarchar2 union all select null::anyrange;
select null::nvarchar2 union all select null::hll_hashval;
select null::nvarchar2 union all select null::hll_trans_type;
select null::nvarchar2 union all select null::byteawithoutorderwithequalcol;
select null::nvarchar2 union all select null::byteawithoutordercol;
select null::nvarchar2 union all select null::anyset;

select null::date union all select null::int16;
select null::date union all select null::record;
select null::date union all select null::cstring;
select null::date union all select null::anyarray;
select null::date union all select null::void;
select null::date union all select null::anyelement;
select null::date union all select null::anynonarray;
select null::date union all select 'red'::rainbow::anyenum;
select null::date union all select null::anyrange;
select null::date union all select null::hll_hashval;
select null::date union all select null::hll_trans_type;
select null::date union all select null::byteawithoutorderwithequalcol;
select null::date union all select null::byteawithoutordercol;
select null::date union all select null::anyset;

select null::time union all select null::int16;
select null::time union all select null::record;
select null::time union all select null::cstring;
select null::time union all select null::anyarray;
select null::time union all select null::void;
select null::time union all select null::anyelement;
select null::time union all select null::anynonarray;
select null::time union all select 'red'::rainbow::anyenum;
select null::time union all select null::anyrange;
select null::time union all select null::hll_hashval;
select null::time union all select null::hll_trans_type;
select null::time union all select null::byteawithoutorderwithequalcol;
select null::time union all select null::byteawithoutordercol;
select null::time union all select null::anyset;

select null::timestamp union all select null::int16;
select null::timestamp union all select null::record;
select null::timestamp union all select null::cstring;
select null::timestamp union all select null::anyarray;
select null::timestamp union all select null::void;
select null::timestamp union all select null::anyelement;
select null::timestamp union all select null::anynonarray;
select null::timestamp union all select 'red'::rainbow::anyenum;
select null::timestamp union all select null::anyrange;
select null::timestamp union all select null::hll_hashval;
select null::timestamp union all select null::hll_trans_type;
select null::timestamp union all select null::byteawithoutorderwithequalcol;
select null::timestamp union all select null::byteawithoutordercol;
select null::timestamp union all select null::anyset;

select null::timestamptz union all select null::int16;
select null::timestamptz union all select null::record;
select null::timestamptz union all select null::cstring;
select null::timestamptz union all select null::anyarray;
select null::timestamptz union all select null::void;
select null::timestamptz union all select null::anyelement;
select null::timestamptz union all select null::anynonarray;
select null::timestamptz union all select 'red'::rainbow::anyenum;
select null::timestamptz union all select null::anyrange;
select null::timestamptz union all select null::hll_hashval;
select null::timestamptz union all select null::hll_trans_type;
select null::timestamptz union all select null::byteawithoutorderwithequalcol;
select null::timestamptz union all select null::byteawithoutordercol;
select null::timestamptz union all select null::anyset;

select null::interval union all select null::int16;
select null::interval union all select null::record;
select null::interval union all select null::cstring;
select null::interval union all select null::anyarray;
select null::interval union all select null::void;
select null::interval union all select null::anyelement;
select null::interval union all select null::anynonarray;
select null::interval union all select 'red'::rainbow::anyenum;
select null::interval union all select null::anyrange;
select null::interval union all select null::hll_hashval;
select null::interval union all select null::hll_trans_type;
select null::interval union all select null::byteawithoutorderwithequalcol;
select null::interval union all select null::byteawithoutordercol;
select null::interval union all select null::anyset;

select null::timetz union all select null::int16;
select null::timetz union all select null::record;
select null::timetz union all select null::cstring;
select null::timetz union all select null::anyarray;
select null::timetz union all select null::void;
select null::timetz union all select null::anyelement;
select null::timetz union all select null::anynonarray;
select null::timetz union all select 'red'::rainbow::anyenum;
select null::timetz union all select null::anyrange;
select null::timetz union all select null::hll_hashval;
select null::timetz union all select null::hll_trans_type;
select null::timetz union all select null::byteawithoutorderwithequalcol;
select null::timetz union all select null::byteawithoutordercol;
select null::timetz union all select null::anyset;

select null::bit union all select null::int16;
select null::bit union all select null::record;
select null::bit union all select null::cstring;
select null::bit union all select null::anyarray;
select null::bit union all select null::void;
select null::bit union all select null::anyelement;
select null::bit union all select null::anynonarray;
select null::bit union all select 'red'::rainbow::anyenum;
select null::bit union all select null::anyrange;
select null::bit union all select null::hll_hashval;
select null::bit union all select null::hll_trans_type;
select null::bit union all select null::byteawithoutorderwithequalcol;
select null::bit union all select null::byteawithoutordercol;
select null::bit union all select null::anyset;

select null::varbit union all select null::int16;
select null::varbit union all select null::record;
select null::varbit union all select null::cstring;
select null::varbit union all select null::anyarray;
select null::varbit union all select null::void;
select null::varbit union all select null::anyelement;
select null::varbit union all select null::anynonarray;
select null::varbit union all select 'red'::rainbow::anyenum;
select null::varbit union all select null::anyrange;
select null::varbit union all select null::hll_hashval;
select null::varbit union all select null::hll_trans_type;
select null::varbit union all select null::byteawithoutorderwithequalcol;
select null::varbit union all select null::byteawithoutordercol;
select null::varbit union all select null::anyset;

select null::year union all select null::int16;
select null::year union all select null::record;
select null::year union all select null::cstring;
select null::year union all select null::anyarray;
select null::year union all select null::void;
select null::year union all select null::anyelement;
select null::year union all select null::anynonarray;
select null::year union all select 'red'::rainbow::anyenum;
select null::year union all select null::anyrange;
select null::year union all select null::hll_hashval;
select null::year union all select null::hll_trans_type;
select null::year union all select null::byteawithoutorderwithequalcol;
select null::year union all select null::byteawithoutordercol;
select null::year union all select null::anyset;

select null::uuid union all select null::int16;
select null::uuid union all select null::record;
select null::uuid union all select null::cstring;
select null::uuid union all select null::anyarray;
select null::uuid union all select null::void;
select null::uuid union all select null::anyelement;
select null::uuid union all select null::anynonarray;
select null::uuid union all select 'red'::rainbow::anyenum;
select null::uuid union all select null::anyrange;
select null::uuid union all select null::hll_hashval;
select null::uuid union all select null::hll_trans_type;
select null::uuid union all select null::byteawithoutorderwithequalcol;
select null::uuid union all select null::byteawithoutordercol;
select null::uuid union all select null::anyset;

select null::uint1 union all select null::int16;
select null::uint1 union all select null::record;
select null::uint1 union all select null::cstring;
select null::uint1 union all select null::anyarray;
select null::uint1 union all select null::void;
select null::uint1 union all select null::anyelement;
select null::uint1 union all select null::anynonarray;
select null::uint1 union all select 'red'::rainbow::anyenum;
select null::uint1 union all select null::anyrange;
select null::uint1 union all select null::hll_hashval;
select null::uint1 union all select null::hll_trans_type;
select null::uint1 union all select null::byteawithoutorderwithequalcol;
select null::uint1 union all select null::byteawithoutordercol;
select null::uint1 union all select null::anyset;

select null::uint2 union all select null::int16;
select null::uint2 union all select null::record;
select null::uint2 union all select null::cstring;
select null::uint2 union all select null::anyarray;
select null::uint2 union all select null::void;
select null::uint2 union all select null::anyelement;
select null::uint2 union all select null::anynonarray;
select null::uint2 union all select 'red'::rainbow::anyenum;
select null::uint2 union all select null::anyrange;
select null::uint2 union all select null::hll_hashval;
select null::uint2 union all select null::hll_trans_type;
select null::uint2 union all select null::byteawithoutorderwithequalcol;
select null::uint2 union all select null::byteawithoutordercol;
select null::uint2 union all select null::anyset;

select null::uint4 union all select null::int16;
select null::uint4 union all select null::record;
select null::uint4 union all select null::cstring;
select null::uint4 union all select null::anyarray;
select null::uint4 union all select null::void;
select null::uint4 union all select null::anyelement;
select null::uint4 union all select null::anynonarray;
select null::uint4 union all select 'red'::rainbow::anyenum;
select null::uint4 union all select null::anyrange;
select null::uint4 union all select null::hll_hashval;
select null::uint4 union all select null::hll_trans_type;
select null::uint4 union all select null::byteawithoutorderwithequalcol;
select null::uint4 union all select null::byteawithoutordercol;
select null::uint4 union all select null::anyset;

select null::uint8 union all select null::int16;
select null::uint8 union all select null::record;
select null::uint8 union all select null::cstring;
select null::uint8 union all select null::anyarray;
select null::uint8 union all select null::void;
select null::uint8 union all select null::anyelement;
select null::uint8 union all select null::anynonarray;
select null::uint8 union all select 'red'::rainbow::anyenum;
select null::uint8 union all select null::anyrange;
select null::uint8 union all select null::hll_hashval;
select null::uint8 union all select null::hll_trans_type;
select null::uint8 union all select null::byteawithoutorderwithequalcol;
select null::uint8 union all select null::byteawithoutordercol;
select null::uint8 union all select null::anyset;

select null::float4 union all select null::int16;
select null::float4 union all select null::record;
select null::float4 union all select null::cstring;
select null::float4 union all select null::anyarray;
select null::float4 union all select null::void;
select null::float4 union all select null::anyelement;
select null::float4 union all select null::anynonarray;
select null::float4 union all select 'red'::rainbow::anyenum;
select null::float4 union all select null::anyrange;
select null::float4 union all select null::hll_hashval;
select null::float4 union all select null::hll_trans_type;
select null::float4 union all select null::byteawithoutorderwithequalcol;
select null::float4 union all select null::byteawithoutordercol;
select null::float4 union all select null::anyset;

select null::float8 union all select null::int16;
select null::float8 union all select null::record;
select null::float8 union all select null::cstring;
select null::float8 union all select null::anyarray;
select null::float8 union all select null::void;
select null::float8 union all select null::anyelement;
select null::float8 union all select null::anynonarray;
select null::float8 union all select 'red'::rainbow::anyenum;
select null::float8 union all select null::anyrange;
select null::float8 union all select null::hll_hashval;
select null::float8 union all select null::hll_trans_type;
select null::float8 union all select null::byteawithoutorderwithequalcol;
select null::float8 union all select null::byteawithoutordercol;
select null::float8 union all select null::anyset;

select null::datetime union all select null::int16;
select null::datetime union all select null::record;
select null::datetime union all select null::cstring;
select null::datetime union all select null::anyarray;
select null::datetime union all select null::void;
select null::datetime union all select null::anyelement;
select null::datetime union all select null::anynonarray;
select null::datetime union all select 'red'::rainbow::anyenum;
select null::datetime union all select null::anyrange;
select null::datetime union all select null::hll_hashval;
select null::datetime union all select null::hll_trans_type;
select null::datetime union all select null::byteawithoutorderwithequalcol;
select null::datetime union all select null::byteawithoutordercol;
select null::datetime union all select null::anyset;

select null::int2vector union all select null::int16;
select null::int2vector union all select null::record;
select null::int2vector union all select null::cstring;
select null::int2vector union all select null::anyarray;
select null::int2vector union all select null::void;
select null::int2vector union all select null::anyelement;
select null::int2vector union all select null::anynonarray;
select null::int2vector union all select 'red'::rainbow::anyenum;
select null::int2vector union all select null::anyrange;
select null::int2vector union all select null::hll_hashval;
select null::int2vector union all select null::hll_trans_type;
select null::int2vector union all select null::byteawithoutorderwithequalcol;
select null::int2vector union all select null::byteawithoutordercol;
select null::int2vector union all select null::anyset;

select null::regproc union all select null::int16;
select null::regproc union all select null::record;
select null::regproc union all select null::cstring;
select null::regproc union all select null::anyarray;
select null::regproc union all select null::void;
select null::regproc union all select null::anyelement;
select null::regproc union all select null::anynonarray;
select null::regproc union all select 'red'::rainbow::anyenum;
select null::regproc union all select null::anyrange;
select null::regproc union all select null::hll_hashval;
select null::regproc union all select null::hll_trans_type;
select null::regproc union all select null::byteawithoutorderwithequalcol;
select null::regproc union all select null::byteawithoutordercol;
select null::regproc union all select null::anyset;

select null::oid union all select null::int16;
select null::oid union all select null::record;
select null::oid union all select null::cstring;
select null::oid union all select null::anyarray;
select null::oid union all select null::void;
select null::oid union all select null::anyelement;
select null::oid union all select null::anynonarray;
select null::oid union all select 'red'::rainbow::anyenum;
select null::oid union all select null::anyrange;
select null::oid union all select null::hll_hashval;
select null::oid union all select null::hll_trans_type;
select null::oid union all select null::byteawithoutorderwithequalcol;
select null::oid union all select null::byteawithoutordercol;
select null::oid union all select null::anyset;

select null::tid union all select null::int16;
select null::tid union all select null::record;
select null::tid union all select null::cstring;
select null::tid union all select null::anyarray;
select null::tid union all select null::void;
select null::tid union all select null::anyelement;
select null::tid union all select null::anynonarray;
select null::tid union all select 'red'::rainbow::anyenum;
select null::tid union all select null::anyrange;
select null::tid union all select null::hll_hashval;
select null::tid union all select null::hll_trans_type;
select null::tid union all select null::byteawithoutorderwithequalcol;
select null::tid union all select null::byteawithoutordercol;
select null::tid union all select null::anyset;

select null::xid union all select null::int16;
select null::xid union all select null::record;
select null::xid union all select null::cstring;
select null::xid union all select null::anyarray;
select null::xid union all select null::void;
select null::xid union all select null::anyelement;
select null::xid union all select null::anynonarray;
select null::xid union all select 'red'::rainbow::anyenum;
select null::xid union all select null::anyrange;
select null::xid union all select null::hll_hashval;
select null::xid union all select null::hll_trans_type;
select null::xid union all select null::byteawithoutorderwithequalcol;
select null::xid union all select null::byteawithoutordercol;
select null::xid union all select null::anyset;

select null::cid union all select null::int16;
select null::cid union all select null::record;
select null::cid union all select null::cstring;
select null::cid union all select null::anyarray;
select null::cid union all select null::void;
select null::cid union all select null::anyelement;
select null::cid union all select null::anynonarray;
select null::cid union all select 'red'::rainbow::anyenum;
select null::cid union all select null::anyrange;
select null::cid union all select null::hll_hashval;
select null::cid union all select null::hll_trans_type;
select null::cid union all select null::byteawithoutorderwithequalcol;
select null::cid union all select null::byteawithoutordercol;
select null::cid union all select null::anyset;

select null::xid32 union all select null::int16;
select null::xid32 union all select null::record;
select null::xid32 union all select null::cstring;
select null::xid32 union all select null::anyarray;
select null::xid32 union all select null::void;
select null::xid32 union all select null::anyelement;
select null::xid32 union all select null::anynonarray;
select null::xid32 union all select 'red'::rainbow::anyenum;
select null::xid32 union all select null::anyrange;
select null::xid32 union all select null::hll_hashval;
select null::xid32 union all select null::hll_trans_type;
select null::xid32 union all select null::byteawithoutorderwithequalcol;
select null::xid32 union all select null::byteawithoutordercol;
select null::xid32 union all select null::anyset;

select null::oidvector union all select null::int16;
select null::oidvector union all select null::record;
select null::oidvector union all select null::cstring;
select null::oidvector union all select null::anyarray;
select null::oidvector union all select null::void;
select null::oidvector union all select null::anyelement;
select null::oidvector union all select null::anynonarray;
select null::oidvector union all select 'red'::rainbow::anyenum;
select null::oidvector union all select null::anyrange;
select null::oidvector union all select null::hll_hashval;
select null::oidvector union all select null::hll_trans_type;
select null::oidvector union all select null::byteawithoutorderwithequalcol;
select null::oidvector union all select null::byteawithoutordercol;
select null::oidvector union all select null::anyset;

select null::oidvector_extend union all select null::int16;
select null::oidvector_extend union all select null::record;
select null::oidvector_extend union all select null::cstring;
select null::oidvector_extend union all select null::anyarray;
select null::oidvector_extend union all select null::void;
select null::oidvector_extend union all select null::anyelement;
select null::oidvector_extend union all select null::anynonarray;
select null::oidvector_extend union all select 'red'::rainbow::anyenum;
select null::oidvector_extend union all select null::anyrange;
select null::oidvector_extend union all select null::hll_hashval;
select null::oidvector_extend union all select null::hll_trans_type;
select null::oidvector_extend union all select null::byteawithoutorderwithequalcol;
select null::oidvector_extend union all select null::byteawithoutordercol;
select null::oidvector_extend union all select null::anyset;

select null::int2vector_extend union all select null::int16;
select null::int2vector_extend union all select null::record;
select null::int2vector_extend union all select null::cstring;
select null::int2vector_extend union all select null::anyarray;
select null::int2vector_extend union all select null::void;
select null::int2vector_extend union all select null::anyelement;
select null::int2vector_extend union all select null::anynonarray;
select null::int2vector_extend union all select 'red'::rainbow::anyenum;
select null::int2vector_extend union all select null::anyrange;
select null::int2vector_extend union all select null::hll_hashval;
select null::int2vector_extend union all select null::hll_trans_type;
select null::int2vector_extend union all select null::byteawithoutorderwithequalcol;
select null::int2vector_extend union all select null::byteawithoutordercol;
select null::int2vector_extend union all select null::anyset;

drop schema union_all cascade;
reset current_schema;