pg_array_cast.sql 253 B

123456789
  1. --!syntax_pg
  2. select
  3. cast(array[1,2,3] as text),
  4. cast('{1,2,3}' as _int4),
  5. cast(array[1,2,3] as _int8),
  6. cast(array[1,2,3] as _text),
  7. cast(array['1',null,'3'] as _int4),
  8. cast(array['{"a":1}'::json,'{"b":2}'::json] as _jsonb),
  9. cast(array[1,2,3] as _oid)