PG Bug reporting form <noreply@postgresql.org> writes:
> WITH RECURSIVE search_tree(id, link, data) AS (
> SELECT t.id, t.link, t.data
> FROM tree t
> UNION ALL
> SELECT t.id, t.link, t.data
> FROM tree t join search_tree st on t.id = st.link
> WHERE t.id < 2
> ) SEARCH DEPTH FIRST BY id SET ordercol
> [42601] ERROR: syntax error at end of input
Yeah ... you wrote a WITH clause, but where's the main SELECT?
> But run ok in PostgreSQL 15.1
I *seriously* doubt that.
regards, tom lane