Hi I am currently looking at how ARRAY types could be converted into tables in H2. In Oracle (or also Postgres), you can have things like this:
------------------------------------------------ CREATE TYPE numbers AS VARRAY(4) OF NUMBER(7); SELECT * FROM TABLE(numbers(2, 3, 5, 7, 11)); ------------------------------------------------ This works in a somewhat similar way to H2's values_expression: http://www.h2database.com/html/grammar.html#values_expression Or to the range_table: http://www.h2database.com/html/grammar.html#range_table However, what if I have an ARRAY table-column or an ARRAY result from a stored function, which I'd like to use as a table to select from? Is that possible? Cheers Lukas -- 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.
