On 18.08.22 20:10, Bruce Momjian wrote:
>> Thus:
>> Strictly speaking, this process is iteration, but <literal>RECURSIVE</literal>
>> is the terminology chosen by the SQL standards committee."
>>
>> Because the above sounds just fine, I'd argue that if one does leave "not
>> recursion" it should be set off by a comma.
> I went with new wording, which should make this even clearer; patch
> attached.
I think this whole note is a bit misleading, like the SQL people don't
know what recursion is. The point is that the query is defined
recursively. The evaluation process is iterative. Those two are not
contradictions.
