Is it possible to list all vertices, edges, and paths in a single column, ordered by their type? The Apache AGE manual does not mention the ability to order these elements, but what query could be used to achieve this?
SELECT *
FROM graph
ORDER BY type
No, it is not possible to list all vertices, edges, and paths in a single column, ordered by their type using the query you provided. The query you provided only selects all columns from the “graph” table and orders them by the “type” column, but it does not differentiate between vertices, edges, and paths. To achieve the desired result, you would need to modify the query and use appropriate filtering conditions based on the type of element you want to retrieve.