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 1qL5SA-002IAe-HM for pgsql-sql@arkaria.postgresql.org; Sun, 16 Jul 2023 17:22:38 +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 1qL5S8-00Gcar-S5 for pgsql-sql@arkaria.postgresql.org; Sun, 16 Jul 2023 17:22:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qL5S8-00Gcai-Ht for pgsql-sql@lists.postgresql.org; Sun, 16 Jul 2023 17:22:36 +0000 Received: from mail-ej1-x630.google.com ([2a00:1450:4864:20::630]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qL5S6-000qS5-6M for pgsql-sql@lists.postgresql.org; Sun, 16 Jul 2023 17:22:35 +0000 Received: by mail-ej1-x630.google.com with SMTP id a640c23a62f3a-9928abc11deso541807666b.1 for ; Sun, 16 Jul 2023 10:22:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1689528153; x=1692120153; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=mmUEoggvAOVecM4NMciLRqJt902Yo+YmuVxQnRcRt5s=; b=H0He5R9a3Gcq7CCUNtm48Xavj1sRBSRjiZYRRFbHYOmyd/HjS0D9WkeVYnF4bGb1DI FwJCGNb2pAxPVjQBsqXWrl7bxnZRffmETz25jH2q11ogiF/67/KHQ3gWN+AJ1OkUkq3O HBafin8kDcWgLcAiICAQ44O1RLy7BnI7gas2mcmUjEfSFKebvSOCRYtc7VASIPAaDpxx nIytJBub10v7gx2jBN70khJnZOg+1uWZ6ONozhV0J9ZZ8gfT8nN+mJyQUG98ip5Tqxaz bZX2rcfzgMdy8e13sGjEQNCXZBCVkqSnCzLXl4TDfeZ0jULCtzV0QUy33qAJjTIPw0Eo 4UBQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1689528153; x=1692120153; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=mmUEoggvAOVecM4NMciLRqJt902Yo+YmuVxQnRcRt5s=; b=X28MytPrU15ndhDcQoOvpurox0y75+ZOo7qsScKAep0rYI4tQnSJZt1sSkKxd67IbV t5FUumaI2e90mWCDCSdB4X58KT0XvYdw+spdfBkGnR6jsTA0EPQ351/WTjv/3kTmVwwf uPajDmKpBcua164Oep3Lkt95QTxu/OkHJVXhPlvEV49T/0UpPX9dVKNjra5wXSed+Osr XgkSwI4KYPYKzWb+41pCryqfFtr4u7pOUVS0sRoxLc23w51fVT9GUOY0dzj+jEmVL4AS V48e0sykFOE6p18kVyfu4oVeBUJLwONtIpzNX1/UhvVCZIiXDLM+n8+sLeJpZDOYjEFs 2plQ== X-Gm-Message-State: ABy/qLZ5+cvzGLPBEto1kEJnXjfkFMakIuBUClLDk6B7nBlXSMg6yXHG NEjlG+wCQrZGFVdePYrKwtzdIvt4mSqzKVtxhPy7cl8g X-Google-Smtp-Source: APBJJlGzvr2/OsyETVZpXydTN5Aq4ETJwDl0Qi7eraOjaib/ErHKQonAe2yJQNUQzH/MDg4/5zHzPLJPtjhy2XS+csk= X-Received: by 2002:a17:906:74de:b0:993:ffcb:ad55 with SMTP id z30-20020a17090674de00b00993ffcbad55mr8854202ejl.9.1689528153099; Sun, 16 Jul 2023 10:22:33 -0700 (PDT) MIME-Version: 1.0 From: Shaozhong SHI Date: Sun, 16 Jul 2023 18:22:21 +0100 Message-ID: Subject: best finding all paths with recursive query To: pgsql-sql Content-Type: multipart/alternative; boundary="0000000000006750ed06009ded76" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000006750ed06009ded76 Content-Type: text/plain; charset="UTF-8" Which is the best example of finding all paths with recursive query? Regards, David --0000000000006750ed06009ded76 Content-Type: text/html; charset="UTF-8"
Which is the best example of finding all paths with recursive query?

Regards,

David
--0000000000006750ed06009ded76--