4 ms·
> In SQL you would have to join the "Edges" table with itself an unknown number of times. In fact fore recent SQL standards have added extensions for these kin
by cmrdporcupine 3y ago
> In SQL you would have to join the "Edges" table with itself an unknown number of times.
In fact fore recent SQL standards have added extensions for these kinds of recursive joins. (And some databases like Oracle, DB2 have had recurse or tclose operators for a long time.)
I don't think they're particularly elegant -- they're awkward like most things in SQL because SQL's syntax sucks -- but the ability is in fact there these days.