Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH horaires(na,id1,heure_passage) AS (
- -- on select d'abord la première heure de passage
- SELECT nomArret AS na, idLigne AS id1, heureDeb AS heure_passage
- FROM passage
- -- boum recursivité
- UNION ALL
- -- on selectionne heure_passage + frequence tant que ce field ne dépasse pas l'heure max
- SELECT na , id1 , (heure_passage + l.frequence) AS hp
- FROM horaires , ligne l , passage p
- WHERE horaires.na = p.nomArret
- AND horaires.id1 = l.idligne
- AND hp < p.heureDeb + l.duree)
- SELECT *
- FROM horaires;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement