Changeset 2616 for trunk/regress/regress_index.sql
- Timestamp:
- 06/04/07 16:06:28 (5 years ago)
- Files:
-
- 1 modified
-
trunk/regress/regress_index.sql (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
trunk/regress/regress_index.sql
r2057 r2616 8 8 CREATE INDEX quick_gist on test using gist (the_geom gist_geometry_ops); 9 9 10 select num, astext(the_geom) from test where the_geom && 'BOX3D(125 125,135 135)'::box3d order by num;10 select num,ST_astext(the_geom) from test where the_geom && 'BOX3D(125 125,135 135)'::box3d order by num; 11 11 12 12 set enable_seqscan = off; 13 13 14 select num, astext(the_geom) from test where the_geom && 'BOX3D(125 125,135 135)'::box3d order by num;14 select num,ST_astext(the_geom) from test where the_geom && 'BOX3D(125 125,135 135)'::box3d order by num; 15 15 16 16 DROP TABLE test;
