{"action":"closed","issue":{"url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/119","labels_url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/119/labels{/name}","comments_url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/119/comments","events_url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/119/events","html_url":"https://github.com/JSQLParser/JSqlParser/issues/119","id":65482314,"number":119,"title":"Support Postgresql WITH RECURSIVE","user":{"login":"grib0","id":6506822,"avatar_url":"https://avatars.githubusercontent.com/u/6506822?v=3","gravatar_id":"","url":"https://api.github.com/users/grib0","html_url":"https://github.com/grib0","followers_url":"https://api.github.com/users/grib0/followers","following_url":"https://api.github.com/users/grib0/following{/other_user}","gists_url":"https://api.github.com/users/grib0/gists{/gist_id}","starred_url":"https://api.github.com/users/grib0/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/grib0/subscriptions","organizations_url":"https://api.github.com/users/grib0/orgs","repos_url":"https://api.github.com/users/grib0/repos","events_url":"https://api.github.com/users/grib0/events{/privacy}","received_events_url":"https://api.github.com/users/grib0/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-03-31T15:47:10Z","updated_at":"2015-04-01T20:31:25Z","closed_at":"2015-04-01T20:31:25Z","body":"```sql\r\nWITH RECURSIVE t(n) AS (\r\n    VALUES (1)\r\n  UNION ALL\r\n    SELECT n+1 FROM t WHERE n < 100\r\n)\r\nSELECT sum(n) FROM t;\r\n```\r\nhttp://www.postgresql.org/docs/9.4/static/queries-with.html"}}