Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qKzBh-0022t2-GD for pgsql-sql@arkaria.postgresql.org; Sun, 16 Jul 2023 10:41:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qKzBf-00CvRw-5G for pgsql-sql@arkaria.postgresql.org; Sun, 16 Jul 2023 10:41:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qKzBe-00CvRo-SF for pgsql-sql@lists.postgresql.org; Sun, 16 Jul 2023 10:41:10 +0000 Received: from mail-ed1-x530.google.com ([2a00:1450:4864:20::530]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qKzBa-000i5s-BD for pgsql-sql@lists.postgresql.org; Sun, 16 Jul 2023 10:41:09 +0000 Received: by mail-ed1-x530.google.com with SMTP id 4fb4d7f45d1cf-52165886aa3so3051952a12.3 for ; Sun, 16 Jul 2023 03:41:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1689504064; x=1692096064; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=B+Si/1XAF3rQwucuzglJyrubH4VT4F7j53LCjeqwnlo=; b=heO5OxY++TRVYu9Tq0RjTmi1Uk5iawKhfDxFM/CUMltMn8MZtR1EsHitrXqsHifTmC qTOC0M/fC5FP8c58j007K1RtqcmXVIcRpgrGAjNOWSycv8M8bveesF7usfSupEJrG0Kj 6TYBkLbH5p9StCKZUdCHJLAIQGtw5ThonccsCJViWfYnpt1GV5Qwg3jCZ+crJFlNQYK2 lgT2e0v9eZlSYuEQYaQH8CzdqzCPffNxsQI+BnVaUHz8UULVNxVdNQmIJ8sreIxaLtTc ESG24I7iOFf5LBzrZbaL+P+aYOZaHuQl0hSrTvIUBKuOxIR4q95ID4j78/UrZqYbF/ay yzGA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1689504064; x=1692096064; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=B+Si/1XAF3rQwucuzglJyrubH4VT4F7j53LCjeqwnlo=; b=V+lxvZFsUf5p1VmcQ5C3PRKENEjouIvlq/81Ofuzlpgw218tveP5A0AHgH9X9lDzGy bln2+AnxHJIb1XfN10FKzPRrZa1jU1CRiIHStiI8yBqG5aV3khnBSMn3mHm7+9J9DPNi fUloQPGM38xdI+aqBslj6dCk0RmTZhdkw5LUldLlA+BWcWF+Qe1riLL1YignuijwP/tz /d2jGf/Zw0gcLBbXJ6n3wilotgUD4Dv3+dVnAPTtPL4Vpvr08OEv/u729xArk8dPjSsl hGQdQ4ln2qPZjGnqHESEZtNLRGNJePXehpQPPdJgJpZzI0IUmc3vHo23ATJVK1JeqsyX MeMA== X-Gm-Message-State: ABy/qLbyJg6khF7TVcULBxM4Ki7yRsKEa/oJtkxLCraTjrNpc7eJ+FLN QMqWmXD1nhrzA/mf45QStZBY/FQdUYcGVHuLEXVDpgdL X-Google-Smtp-Source: APBJJlHWDqgWfxgywo0JSBkpDjoYN1zJeckyM7FrNLYlaNigcyzqNshtH6obmotOyMSgl5/Xd4/QqjXKwTPD63o1QVM= X-Received: by 2002:a17:906:151:b0:992:8092:c109 with SMTP id 17-20020a170906015100b009928092c109mr8580950ejh.51.1689504063681; Sun, 16 Jul 2023 03:41:03 -0700 (PDT) MIME-Version: 1.0 From: Shaozhong SHI Date: Sun, 16 Jul 2023 11:40:52 +0100 Message-ID: Subject: Multiple sets of results from recursive query To: pgsql-sql Content-Type: multipart/alternative; boundary="0000000000008ff78d0600985103" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008ff78d0600985103 Content-Type: text/plain; charset="UTF-8" Has anyone come across multiple sets of results with recursive query? How to handle it? Regards, David --0000000000008ff78d0600985103 Content-Type: text/html; charset="UTF-8"
Has anyone come across multiple sets of results with recursive query?

How to handle it?

Regards,

David
--0000000000008ff78d0600985103--