with_rec_all_empty.sql « pg « suites « sql « tests « essentials « yql - ydb - Mirror of YDB github repos

about summary refs log tree commit diff stats

path: root/yql/essentials/tests/sql/suites/pg/with_rec_all_empty.sql

blob: 84deddc383befc594b9d64c856dbe489b5ae8321 (plain) (blame)

--!syntax_pg
WITH RECURSIVE t(n) AS (
    SELECT * FROM (SELECT 1 LIMIT 0) a
    UNION ALL
    SELECT n+1 FROM t WHERE n < 5
)
SELECT * FROM t