U++

http://www.postgresql.org/docs/8.4/static/queries-with.html

WITH RECURSIVE r(parent_id, name, id, t) AS
(
/*Prvni iterace*/
(
(select parent_id, name, id, 0
from treenode
where nodeid = '170401000'
)
union
(select d.parent_id, d.name, d.id, 10
from treenode o inner join treenode d
on d.doubled_id = o.id
where o.nodeid = '170401000'
)
)
UNION ALL
/*Iterace dokud neco pribyva*/
select p.parent_id, p.name, p.id, r.t+1
from treenode p inner join r
on r.parent_id = p.id
where p.id > 0 and r.id not in
(
select treenode_id from treenode_attr
where entity = -106
)
)
select * from r order by r.t;