Confused, why can't you just do something like this? SELECT name FROM user CROSS... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

dataflow on Sept 18, 2019 | parent | context | favorite | on: New Query Language for Graph Databases to Become I...

Confused, why can't you just do something like this?

  SELECT name FROM user
  CROSS JOIN friend ON id2 = user.id
  GROUP BY id2 HAVING COUNT(id2) = 4

zaphar on Sept 18, 2019 [–]

That can only query for a depth of 1. It doesn't let you query for friends of friends at an arbitrary depth.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact