Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM m;
- a.com|CNAME|b.net
- b.net|CNAME|c0.org
- c.org|A|127.0.0.1
- c.org|A|127.0.0.2
- c0.org|CNAME|c1.org
- c1.org|CNAME|c.org
- e.com|CNAME|f.com
- f.com|CNAME|g.com
- g.com|CNAME|h.com
- h.com|CNAME|e.com
- i.com|CNAME|j.com
- WITH RECURSIVE cname(record, TYPE, DATA) AS (
- SELECT record, TYPE, DATA
- FROM m
- WHERE TYPE = 'CNAME'
- UNION
- SELECT cname.record, m.TYPE, m.DATA
- FROM
- cname
- JOIN m ON (m.record=cname.DATA)
- )
- SELECT *
- FROM
- m
- LEFT JOIN cname ON (
- m.TYPE = 'CNAME'
- AND cname.TYPE <> 'CNAME'
- AND cname.record = m.record
- )
- ;
- a.com|CNAME|b.net|a.com|A|127.0.0.1
- a.com|CNAME|b.net|a.com|A|127.0.0.2
- b.net|CNAME|c0.org|b.net|A|127.0.0.1
- b.net|CNAME|c0.org|b.net|A|127.0.0.2
- c.org|A|127.0.0.1|||
- c.org|A|127.0.0.2|||
- c0.org|CNAME|c1.org|c0.org|A|127.0.0.1
- c0.org|CNAME|c1.org|c0.org|A|127.0.0.2
- c1.org|CNAME|c.org|c1.org|A|127.0.0.1
- c1.org|CNAME|c.org|c1.org|A|127.0.0.2
- e.com|CNAME|f.com|||
- f.com|CNAME|g.com|||
- g.com|CNAME|h.com|||
- h.com|CNAME|e.com|||
- i.com|CNAME|j.com|||
Advertisement
Add Comment
Please, Sign In to add comment
