--!syntax_pg
select 
cast(array[1,2,3] as text), 
cast('{1,2,3}' as _int4),
cast(array[1,2,3] as _int8),
cast(array[1,2,3] as _text),
cast(array['1',null,'3'] as _int4),
cast(array['{"a":1}'::json,'{"b":2}'::json] as _jsonb),
cast(array[1,2,3] as _oid)