Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[PGQL] Retrieve the paths using PATH pattern macro

User_DL7M6Mar 25 2021 — edited Mar 25 2021

Is it possible to retrieve the list of nodes and edges on the paths using PATH pattern macro?

My understanding is that only the list of nodes (= `y` below) can be retrieved, but not the list of edges nor the list of paths. Please suggest if there is any workaround.

SELECT y.name

FROM MATCH (x:Person) -/:likes*/-> (y)

WHERE x.name = 'Amy'

https://pgql-lang.org/spec/1.3/#examples-with-various-quantifiers

Thanks.

Amy

---
PGQL-RDBM, Graph Server and Client 21.1

Comments
Post Details
Added on Mar 25 2021
1 comment
290 views