I am interested in using recursive query within a view. With H2db, the following recursive query works well for me.
with recursive t (d, a ) as ( select child, parent from abc union all select t.d, abc.parent from abc, t where t.a = abc.child) select * from t ; However, when I try to create a view with the recursive query it fails: I tried the following create view vv as with recursive t (d, a ) as ( select child, parent from abc union all select t.d, abc.parent from abc, t where t.a = abc.child) select * from t Please guide me how I can create a view which uses recursive query. Regards Rajagopal -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
