]> pd.if.org Git - dumppoints/blob - t/point.sql
added email address to README
[dumppoints] / t / point.sql
1 begin;
2         select plan(1);
3
4 select results_eq(
5         $want$
6         SELECT path, ST_AsText(geom) 
7         FROM (
8           SELECT (dp.ST_DumpPoints(g.geom)).* 
9           FROM
10             (SELECT 
11                'POINT (0 9)'::geometry AS geom
12             ) AS g
13           ) j;
14         $want$,
15         $have$
16         values ('{1}'::int[], 'POINT(0 9)');
17         $have$,
18         'single point'
19 );
20
21 select finish();
22
23 rollback;
24 \q
25