[GitHub] [age] Hamza-Mushtaque commented on issue #820: Are multiple cypher calls possible within the same FROM clause?

["Hamza-Mushtaque (via GitHub)" <gi...@apache.org>]

Hamza-Mushtaque commented on issue #820:
URL: https://github.com/apache/age/issues/820#issuecomment-1557969675

   This is working as intended because you are not allowed to use same table name ("cypher") more than once in the same `FROM` clause and it is not possible use multiple cypher calls in same `from` clause.
   But it is possible to run separate multiple Cypher queries and then combine their results using Joins.
   Checkout below query for reference.
   
   ```
   SELECT *
   FROM (
     SELECT * FROM cypher('query1')  -- Subquery 1
   ) AS result1
   CROSS JOIN (
     SELECT * FROM cypher('query2')  -- Subquery 2
   ) AS result2;
   
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org