Re: pgsql: doc: clarify recursion internal behavior

2022-09-28 Thread Bruce Momjian
On Thu, Sep 8, 2022 at 11:30:04AM -0400, Tom Lane wrote: > Robert Haas writes: > > On Thu, Sep 8, 2022 at 7:24 AM Peter Eisentraut > > wrote: > >> On 03.09.22 03:58, Bruce Momjian wrote: > >>> +While RECURSIVE allows queries to be specified > >>> +recursively, internally all queries are

Re: pgsql: doc: clarify recursion internal behavior

2022-09-08 Thread Tom Lane
Robert Haas writes: > On Thu, Sep 8, 2022 at 7:24 AM Peter Eisentraut > wrote: >> On 03.09.22 03:58, Bruce Momjian wrote: >>> +While RECURSIVE allows queries to be specified >>> +recursively, internally all queries are evaluated iteratively. >> Is that true? Surely there is some recursi

Re: pgsql: doc: clarify recursion internal behavior

2022-09-08 Thread Robert Haas
On Thu, Sep 8, 2022 at 7:24 AM Peter Eisentraut wrote: > On 03.09.22 03:58, Bruce Momjian wrote: > > doc: clarify recursion internal behavior > > -Strictly speaking, this process is iteration not recursion, but > -RECURSIVE is the terminology chosen by the SQL > standards > -committee

Re: pgsql: doc: clarify recursion internal behavior

2022-09-08 Thread Peter Eisentraut
On 03.09.22 03:58, Bruce Momjian wrote: doc: clarify recursion internal behavior -Strictly speaking, this process is iteration not recursion, but -RECURSIVE is the terminology chosen by the SQL standards -committee. +While RECURSIVE allows queries to be specified +recursi