postgres recursive queries

gistfile1.sql

WITH RECURSIVE friendship_tree(id, name, path) AS (
  SELECT id, name, ARRAY[id]
  FROM members
  WHERE members.h1 LIKE '%Cortina%'
UNION ALL
  SELECT members.id, members.name, path || members.id
  FROM friendship_tree
  JOIN friendships ON friendships.friend_id = friendship_tree.id
  JOIN members ON members.id = friendships.member_id
  WHERE NOT members.id = ANY(path)
)
SELECT * FROM friendship_tree ORDER BY path;