Changes between Initial Version and Version 1 of Ticket #689


Ignore:
Timestamp:
12/08/10 15:14:20 (14 years ago)
Author:
robe
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • TabularUnified Ticket #689 – Description

    initial v1  
    1212{{{
    1313
    14 "SELECT ST_CoveredBy(foo1.the_geom, foo2.the_geom) As result, ST_AsText(foo1.the_geom) As ref1_geom, ST_AsText(foo2.the_geom) As ref2_geom
     14SELECT ST_CoveredBy(foo1.the_geom, foo2.the_geom) As result, ST_AsText(foo1.the_geom) As ref1_geom, ST_AsText(foo2.the_geom) As ref2_geom
    1515        FROM ((SELECT ST_GeomFromText('GEOMETRYCOLLECTION EMPTY',4326) As the_geom
    1616                        UNION ALL SELECT ST_GeomFromText('POLYGON EMPTY',4326) As the_geom
    … …  
    1919                        UNION ALL SELECT ST_GeomFromText('MULTIPOLYGON EMPTY',4326) As the_geom
    2020                        UNION ALL SELECT ST_GeomFromText('LINESTRING EMPTY',4326) As the_geom
    21                         UNION ALL SELECT ST_GeomFromText('MULTILINESTRING EMPTY',4326) As the_geom ) ) As foo1 CROSS JOIN ((SELECT ST_MakeLine(ST_SetSRID(ST_MakePointM(i,j,m),4326),ST_SetSRID(ST_MakePointM(j,i,m),4326)) As the_geom FROM generate_series(-10,50,10) As i CROSS JOIN generate_series(50,70, 20) As j CROSS JOIN generate_series(1,2) As m WHERE NOT(i = j) ORDER BY i, j, m, i*j*m)) As foo2;
     21                        UNION ALL SELECT ST_GeomFromText('MULTILINESTRING EMPTY',4326) As the_geom ) ) As foo1 CROSS JOIN ((SELECT ST_MakeLine(ST_SetSRID(ST_MakePointM(i,j,m),4326),ST_SetSRID(ST_MakePointM(j,i,m),4326)) As the_geom FROM generate_series(-10,50,10) As i CROSS JOIN generate_series(50,70, 20) As j CROSS JOIN generate_series(1,2) As m WHERE NOT(i = j) ORDER BY i, j, m, i*j*m)) As foo2 LIMIT 2;
    2222}}}