with_rec_distinct.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_distinct.sql

blob: fc2d879ac1d773015cfe6ff3a78f1f35a8332447 (plain) (blame)

--!syntax_pg
WITH RECURSIVE t(n) AS (
    SELECT 1
    UNION 
    SELECT 1 FROM t
)
SELECT * FROM t