5.2 Variable Length Path Patterns

Variable length graph patterns provide advanced querying support for SQL property graphs.

Variable length graph patterns require recursion such that there is a variable number of joins when translated into a relational query.

Bounded recursive path patterns that include one or more of the following quantifiers are supported:

Table 5-3 Quantifier Support for Variable Length Graph Patterns

Quantifier Description
{n} Exactly n
{n, m} Between n and m (inclusive)
{, m} Between 0 and m (inclusive)

Note that the maximum upper bound limit for the quantifiers in the preceding table is 10.

See Example 5-14 for example queries using recursive path patterns with bounded quantifiers.