Revision 47579 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.sqlite/org.gvsig.sqlite.provider/src/test/resources/org/gvsig/sqlite/dal/calculateEnvelope.sql
calculateEnvelope.sql | ||
---|---|---|
1 | 1 |
|
2 |
-- Count SQL
|
|
2 |
-- Calculate envelope SQL
|
|
3 | 3 |
SELECT |
4 |
NVL2(ST_Extent("PUBLIC"."test"."Geometry"),ST_AsBinary(ST_Extent("PUBLIC"."test"."Geometry")),NULL) |
|
5 |
FROM "PUBLIC"."test" |
|
6 |
WHERE ( ("PUBLIC"."test"."Geometry") IS NOT NULL ); |
|
4 |
IIF(ST_ExtentAggregate("test"."Geometry") IS NULL,NULL, |
|
5 |
ST_AsBinary(ST_ExtentAggregate("test"."Geometry"))) |
|
6 |
FROM "test" |
|
7 |
WHERE ( ("test"."Geometry") IS NOT NULL ); |
Also available in: Unified diff