Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*definicija rekurzije*/
- with recursive upit (preduvjet, kolegij) as (
- select preduvjet, kolegij from preduvjet_kolegij
- union
- select pk.preduvjet, u.kolegij from preduvjet_kolegij pk inner join upit u
- on pk.kolegij = u.preduvjet
- )
- select * from upit;
- /* rekurzija- zaposlenici*/
- create view zaposlenik select n.prezime as nadredeni, p.prezime as podredeni
- from zaposlenik n inner join zaposlenik p
- on p.nadreden = n.zaposlenik_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement