pgsql: doc: clarify recursion internal behavior

doc: clarify recursion internal behavior

Reported-by: Drew DeVault

Discussion: /messages/by-id/20211018091720.31299-1-sir@cmpwn.com

Backpatch-through: 10

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/1525711588c87b80965594ff2249773d8d1ee5c9

Modified Files
--------------
doc/src/sgml/queries.sgml | 5 ++---
1 file changed, 2 insertions(+), 3 deletions(-)