neo4j - 相当于neo4j中的row_number

Question

我正在尝试运行一个查询，根据它们在查询中出现的顺序分配整数。我希望它发挥作用:
MATCH users RETURN users ORDER BY created_at SET user.number=ROW_NUMBER()
有没有办法在单个查询中做到这一点？谢谢!

Answer 1

你可以通过玩一个集合来做到这一点:

MATCH (n:User)
WITH n
ORDER BY n.created_at
WITH collect(n) as users
UNWIND range(0, size(users)-1) as pos
SET (users[pos]).number = pos