Revision 1115 trunk/org.gvsig.postgresql/org.gvsig.postgresql.provider/src/test/resources/org/gvsig/postgresql/dal/resultSetForSetProvider.sql

View differences:

resultSetForSetProvider.sql
1 1 

  		




  2
  2
  
    
-- ResultSetForSetProvider SQL


  		




  3
  
  
    
SELECT 


  		




  4
  
  
    
    "ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", 


  		




  5
  
  
    
    "Bool2", "String", "Bool3", "Double", "Bool4", "Float", "Bool5", "Decimal", 


  		




  6
  
  
    
    ST_AsBinary("Geometry") 


  		




  7
  
  
    
  FROM "dbtest"."public"."test" ORDER BY "ID" ASC;


  		




  
  3
  
    
SELECT "dbtest"."public"."test"."ID", 


  		




  
  4
  
    
       "dbtest"."public"."test"."Byte", 


  		




  
  5
  
    
       "dbtest"."public"."test"."Bool1", 


  		




  
  6
  
    
       "dbtest"."public"."test"."Long", 


  		




  
  7
  
    
       "dbtest"."public"."test"."Timestamp", 


  		




  
  8
  
    
       "dbtest"."public"."test"."Date", 


  		




  
  9
  
    
       "dbtest"."public"."test"."Time", 


  		




  
  10
  
    
       "dbtest"."public"."test"."Bool2", 


  		




  
  11
  
    
       "dbtest"."public"."test"."String", 


  		




  
  12
  
    
       "dbtest"."public"."test"."Bool3", 


  		




  
  13
  
    
       "dbtest"."public"."test"."Double", 


  		




  
  14
  
    
       "dbtest"."public"."test"."Bool4", 


  		




  
  15
  
    
       "dbtest"."public"."test"."Float", 


  		




  
  16
  
    
       "dbtest"."public"."test"."Bool5", 


  		




  
  17
  
    
       "dbtest"."public"."test"."Decimal", 


  		




  
  18
  
    
       ST_AsBinary("dbtest"."public"."test"."Geometry") 


  		




  
  19
  
    
FROM "dbtest"."public"."test" 


  		




  
  20
  
    
ORDER BY "dbtest"."public"."test"."ID" ASC;


  		












Also available in:  Unified diff