Changes between Version 7 and Version 8 of Problèmes rencontrés et requêtes


Ignore:
Timestamp:
May 6, 2010 9:17:52 AM (15 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Problèmes rencontrés et requêtes

    v7 v8  
    6464select fra_note from geobs2010.franchissabilite_piscicole where fra_note '^(-)?[0-9]*\\.?[0-9]+$' order by fra_note; 
    6565}}} 
     66 
     67 
     68== Requête pour récuperer le nb d'obstacle, la somme des hauteurs == 
     69{{{ 
     70select count(*) as nb_dams, sum(ref_hauteur_chute) as c_height, sum(ref_hauteur_terrain) as c_height_terrain, gid as gid from geobs2010.obstacle_referentiel r natural join geobs2010.roe_ccm_300 group by gid; 
     71}}}