Thanks for the response.
On 15 jul, 20:40, Thomas Mueller <[email protected]> wrote: > 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.
