pg_array_literal.sql 325 B

123456789101112131415
  1. --!syntax_pg
  2. select
  3. array['a','b'] a1,
  4. array[array['a','b']] a2,
  5. array[array['a','b'],array['c','d']] a3,
  6. array['a',null] a4,
  7. array[null] a5,
  8. array[1] a6,
  9. array[1,2] a7,
  10. array[null::int4,2] a8,
  11. array[array[1,2]] a9,
  12. array[array[1,2],array[3,4]] a10,
  13. array_out(array[1,2]) a11,
  14. array_out(array[null,'NULL','',',','{}']) a12