With Recursive no work, Postgresql

#1

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;

#2

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

3.1.1 Metabase
9.6.3 Postgres

#4

Sorry 0.31.1 rather. . .

#5

Just started working. . . go figure.