This thread shows an example of the “WITH RECURSIVE” method working. . .
however this simple examples does not.
WITH RECURSIVE tens (n) AS (
SELECT 10
UNION ALL
SELECT n+10 FROM tens WHERE n+10<= 100
)
SELECT n FROM tens;
This thread shows an example of the “WITH RECURSIVE” method working. . .
however this simple examples does not.
WITH RECURSIVE tens (n) AS (
SELECT 10
UNION ALL
SELECT n+10 FROM tens WHERE n+10<= 100
)
SELECT n FROM tens;
Hi @aawood
Which version of Postgres and Metabase?
I’ve just tested the snippet and it works on Metabase 0.32.5 and Postgres 11.2
3.1.1 Metabase
9.6.3 Postgres
Sorry 0.31.1 rather. . .
Just started working. . . go figure.