Revision 47606 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.sqlite/org.gvsig.sqlite.provider/src/test/resources/org/gvsig/sqlite/dal/calculateEnvelope.sql

View differences:

calculateEnvelope.sql
1 1 

  		




  2
  2
  
    
-- Calculate envelope SQL


  		




  3
  
  
    
SELECT 


  		




  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 );


  		




  
  3
  
    
SELECT ( ST_Extent("test"."Geometry") ) FROM "test" WHERE ( ("test"."Geometry") IS NOT NULL );


  		












Also available in:  Unified diff