SQLite Forum

SQLite3 Array?
Login
At [this location](https://www.sqlite.org/draft/lang_with.html) I read the following:

>Thus the input string:
53..7....6..195....98....6.8...6...34..8.3..17...2...6.6....28....419..5....8..79
Corresponds to a puzzle like this: (this is depicted as a 2D array).

The <u>whole</u> query works; however, I am interested in simply reading a numeric vector into what seems to be a 2D array.

This does not work:
```
WITH RECURSIVE
   input(sud) AS (  VALUES('53,,7,,,,6,,195,,,,98,,,,6,8,,,6,,,34,,8,3,,17,,,2,,,6,6,,,,28,,,,419,,5,,,,8,,79')
  ) SELECT * FROM input;
```

How do I build an array from a numeric vector? And use it to solve a [shortest path problem as described here](https://learnsql.com/blog/get-to-know-the-power-of-sql-recursive-queries/)?