bitnine-oss / agensgraph

AgensGraph, a transactional graph database based on PostgreSQL
http://www.agensgraph.org
Other
1.33k stars 148 forks source link

How do i search by id? #540

Closed afidegnum closed 3 years ago

afidegnum commented 3 years ago

None of these query worked.


MATCH (p:Person {id(p): '3.2'}) return p;

MATCH (p:Person {id: '3.2'}) return p;

MATCH (p:Person {vid: '3.2'}) return p;

which one works?

emotionbug commented 3 years ago

Use this.

MATCH (p:Person) WHERE id(n) = 3.14 return p;
afidegnum commented 3 years ago

Thanks a lot, what does n stand for ?

afidegnum commented 3 years ago

it's rather p not n MATCH (p:Person) WHERE id(p) = 3.14 return p; Thanks a lot

afidegnum commented 3 years ago

Another little question again, what will be the query if i want to match 2 edges by id? MATCH (p:person {name: 'John'}),(k:person{name: 'Daniel'}) CREATE (p)-[:knows]->(k) so, instead of matching by name, i want to match by ID

emotionbug commented 3 years ago

use like this.

MATCH (p:person),(k:person)
WHERE id(p) = 1 AND id(k) = 2
CREATE (p)-[:knows]->(k)
afidegnum commented 3 years ago

thanks