Re: BUG #17708: 12.4

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