pd.if.org Git - dumppoints/blob - t/multipoly.sql

   1 begin;
   2         select plan(1);
   3
   4 select results_eq(
   5         $have$
   6         SELECT path, ST_AsText(geom)
   7         FROM (
   8           SELECT (dp.ST_DumpPoints(g.geom)).*
   9           FROM
  10             (SELECT
  11                'MULTIPOLYGON (((
  12                         0 0,
  13                         0 3,
  14                         4 3,
  15                         4 0,
  16                         0 0
  17                     )), ((
  18                         2 4,
  19                         1 6,
  20                         4 5,
  21                         2 4
  22                     ), (
  23                         7 6,
  24                         6 8,
  25                         8 8,
  26                         7 6
  27                     )))'::geometry AS geom
  28             ) AS g
  29           ) j;
  30         $have$,
  31         $want$
  32             values
  33                 ('{1,1,1}'::int[], 'POINT(0 0)'),
  34                 ('{1,1,2}'::int[], 'POINT(0 3)'),
  35                 ('{1,1,3}'::int[], 'POINT(4 3)'),
  36                 ('{1,1,4}'::int[], 'POINT(4 0)'),
  37                 ('{1,1,5}'::int[], 'POINT(0 0)'),
  38                 ('{2,1,1}'::int[], 'POINT(2 4)'),
  39                 ('{2,1,2}'::int[], 'POINT(1 6)'),
  40                 ('{2,1,3}'::int[], 'POINT(4 5)'),
  41                 ('{2,1,4}'::int[], 'POINT(2 4)'),
  42                 ('{2,2,1}'::int[], 'POINT(7 6)'),
  43                 ('{2,2,2}'::int[], 'POINT(6 8)'),
  44                 ('{2,2,3}'::int[], 'POINT(8 8)'),
  45                 ('{2,2,4}'::int[], 'POINT(7 6)');
  46         $want$,
  47         'multipolygon'
  48 );
  49
  50 select finish();
  51
  52 rollback;
  53 \q
  54