How can I Unnest (like in PostgreSQL) or Unwind (like in Neo4j) a collection/array in query results. Please note that what I am searching for is "not" the Expand keyword, which entirely replaces a dataset. Here is the use case of the query I want to run:
For table 't': f1 | f2 | f3 ----|-----------|---- a | [1,2,3,4] | d b | [5,6] | e c | [7] | f I want to run: SELECT f1, UNNEST(f2) AS f2s, f3 And get: f1 | f2s | f3 ----|-----|---- a | 1 | d a | 2 | d a | 3 | d a | 4 | d b | 5 | e b | 6 | e c | 7 | f This is the most basic thing one needs to obtain when dealing with traversing selects, but I can't seem to make it work on OrientDB. Any idea? Mahmood -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
