← Back to branch summary

~aglenyoung/+junk/postgres-9.3-dtrace

« back to all changes in this revision

Viewing changes to src/test/regress/sql/arrays.sql

  • Committer: Package Import Robot
  • Author(s): Martin Pitt, Christoph Berg, Martin Pitt
  • Date: 2013-06-26 15:13:32 UTC
  • mfrom: (1.1.1)
  • Revision ID: package-import@ubuntu.com-20130626151332-p34yjpn0txbdsdzd
Tags: 9.3~beta2-1
[ Christoph Berg ]
* hurd-i386: Ignore testsuite failures so we have a working libpq5 (they
  don't implement semaphores so the server won't even start).
* Mark postgresql-9.3 as beta in the description, suggested by Joshua D.
  Drake.

[ Martin Pitt ]
* New upstream release 9.3 beta2.

Show diffs side-by-side

added added

removed removed

Lines of Context:
src/test/regress/sql/arrays.sql
432
432
select unnest(array[1,2,3,4.5]::numeric[]);
433
433
select unnest(array[1,2,3,null,4,null,null,5,6]);
434
434
select unnest(array[1,2,3,null,4,null,null,5,6]::text[]);
 
435
select abs(unnest(array[1,2,null,-3]));
435
436
select array_remove(array[1,2,2,3], 2);
436
437
select array_remove(array[1,2,2,3], 5);
437
438
select array_remove(array[1,NULL,NULL,3], NULL);
438
439
select array_remove(array['A','CC','D','C','RR'], 'RR');
439
440
select array_remove('{{1,2,2},{1,4,3}}', 2); -- not allowed
 
441
select array_remove(array['X','X','X'], 'X') = '{}';
440
442
select array_replace(array[1,2,5,4],5,3);
441
443
select array_replace(array[1,2,5,4],5,NULL);
442
444
select array_replace(array[1,2,NULL,4,NULL],NULL,5);