Hi, Currently it's not supported, but I am working on it. The plan is to support ANSI SQL standard 'common table expression'. The syntax is a bit strange:
with recursive t(n) as (select 1 union all select n+1 from t where n<10) select * from t; -- returns 1 .. 10 with recursive t(n) as (select 1 union all select n+1 from t where n<10) select * from t; -- returns 1, 2, 4, 8, 16 This should be available in the next release (however it's still experimental). Regards, Thomas -- 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.
