yql/essentials/tests/sql/suites/pg/pg_array_cast.sql


1
2
3
4
5
6
7
8
9

--!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)