*** pgsql/src/test/regress/sql/arrays.sql	2010/02/18 18:41:47	1.37
--- pgsql/src/test/regress/sql/arrays.sql	2010/08/10 21:51:00	1.38
*************** select string_to_array('1||2|3||', '||')
*** 383,389 ****
  select string_to_array('1|2|3', '');
  select string_to_array('', '|');
  select string_to_array('1|2|3', NULL);
! select string_to_array(NULL, '|');
  
  select array_to_string(string_to_array('1|2|3', '|'), '|');
  
--- 383,403 ----
  select string_to_array('1|2|3', '');
  select string_to_array('', '|');
  select string_to_array('1|2|3', NULL);
! select string_to_array(NULL, '|') IS NULL;
! select string_to_array('abc', '');
! select string_to_array('abc', '', 'abc');
! select string_to_array('abc', ',');
! select string_to_array('abc', ',', 'abc');
! select string_to_array('1,2,3,4,,6', ',');
! select string_to_array('1,2,3,4,,6', ',', '');
! select string_to_array('1,2,3,4,*,6', ',', '*');
! 
! select array_to_string(NULL::int4[], ',') IS NULL;
! select array_to_string('{}'::int4[], ',');
! select array_to_string(array[1,2,3,4,NULL,6], ',');
! select array_to_string(array[1,2,3,4,NULL,6], ',', '*');
! select array_to_string(array[1,2,3,4,NULL,6], NULL);
! select array_to_string(array[1,2,3,4,NULL,6], ',', NULL);
  
  select array_to_string(string_to_array('1|2|3', '|'), '|');
  
