WITH RECURSIVE my_func error

[BrandiATMuhkuh]

When writing a recursive function starting with
WITH RECURSIVE my_func() as ()

I'll get the following error

>  Unexpected word token: "my_func". Instead, I was expecting to see one of the following:
> 
>      - A "kw_as" token

Postgres documentation for this feature: https://www.postgresql.org/docs/9.1/queries-with.html
https://www.postgresqltutorial.com/postgresql-recursive-query/

[BrandiATMuhkuh]

Is there a way I can contribute? I saw you use a DSL for the parser, but I don't have the expertise on how to use it.

[oguimbal]

Hi, it's coming soon !

Incidentally, your request has lead me to a non trivial refactoring... thus the delay :)

[BrandiATMuhkuh]

I see. Thanks man. I'm not surprised. A DSL that can handle recursion is surely not trivial! Thanks!

[oguimbal]

Hi !

Fixed in pgsql-ast-parser@8.1.0 (finally !)

See breaking changes with the 8.0.0 major release.

Sorry for the delay :)

[BrandiATMuhkuh]

Awesome. I'll give it a go tomorrow.
No need to say sorry. You are duing this for free for us. I'm super thankful for what you do!

[BrandiATMuhkuh]

Sorry, It took me longer then expected. I found an issue related to the RECURSIVE function. I made the following issue for it #44