Project

General

Profile

« Previous | Next » 

Revision 13093

Added by Aaron Marcuse-Kubitza almost 11 years ago

fix: schemas/vegbien.sql: _specimens_11_list_of_three_standard_political_divisions: use same column names as input query

View differences:

trunk/schemas/vegbien.sql
9095 9095 

  		




  9096
  9096
  
    
CREATE VIEW _specimens_11_list_of_three_standard_political_divisions AS


  		




  9097
  9097
  
    
 SELECT DISTINCT place.country, 


  		




  9098
  
  
    
    place.stateprovince, 


  		




  
  9098
  
    
    place.stateprovince AS "stateProvince", 


  		




  9099
  9099
  
    
    place.county


  		




  9100
  9100
  
    
   FROM public.place


  		




  9101
  9101
  
    
  WHERE (place.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname));


  		












Also available in:  Unified diff