Revision 46505 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.h2spatial/org.gvsig.h2spatial.h2gis132/org.gvsig.h2spatial.h2gis132.provider/src/test/resources/org/gvsig/fmap/dal/store/h2/calculateEnvelope.sql

View differences:

calculateEnvelope.sql
1 1 

  		




  2
  2
  
    
-- Count SQL


  		




  3
  3
  
    
SELECT 


  		




  4
  
  
    
  NVL2(ST_Extent("Geometry"),ST_AsBinary(ST_Extent("Geometry")),NULL) 


  		




  5
  
  
    
  FROM "PUBLIC"."test" 


  		




  6
  
  
    
  WHERE ( ("Geometry") IS NOT NULL );


  		




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


  		












Also available in:  Unified diff