PolarDB：多標籤查詢

多標籤表達

多標籤之間使用|進行分隔，如下：

(n:Person|Company)
[p:KNOWS|LIKES]

資料準備

SELECT create_graph('imdb');
SELECT *
FROM cypher('imdb', $$
 CREATE (toby:actor {name: 'Toby Maguire'}),
  (willam:director {name: 'Willam Dafoe'}),
  (hanks:person {name: 'Tom Hanks'}),
  (spiderman:movie {title: 'Spiderman'}),
  (toby)-[:acted_in]->(spiderman),
  (willam)-[:directed]->(spiderman),
  (hanks)-[:likes]->(spiderman)
$$) AS (a agtype);

樣本

• 查詢標籤為actor或director的人名。

  SELECT * FROM cypher('imdb', $$
  MATCH (a:actor|director) 
  RETURN a.name
  $$
  ) as (name agtype);

  返回結果如下：

        name      
  ----------------
   "Toby Maguire"
   "Willam Dafoe"
  (2 rows)

• 查詢在directed或acted_in關係中，與電影Spiderman有聯絡的人。

  SELECT * FROM cypher('imdb', $$
  MATCH (p)-[r:acted_in|directed]->(:movie {title: 'Spiderman'}) 
  RETURN p.name
  $$
  ) as (name agtype);

  返回結果如下：

        name      
  ----------------
   "Toby Maguire"
   "Willam Dafoe"
  (2 rows)