Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mzHS0-0004xA-94 for pgsql-docs@arkaria.postgresql.org; Mon, 20 Dec 2021 12:07:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mzHRz-0003jV-22 for pgsql-docs@arkaria.postgresql.org; Mon, 20 Dec 2021 12:07:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mzH2U-00070d-CJ for pgsql-docs@lists.postgresql.org; Mon, 20 Dec 2021 11:41:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mzH2P-0002zF-P2 for pgsql-docs@lists.postgresql.org; Mon, 20 Dec 2021 11:41:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=u6vPJFJWB54Q6R1+7qhsjhQjTE+ocQaRxno/dCNi5ko=; b=tdxba6P5O6KDcwGFk3qXHHmWEi 6Rh1k1wWrNluX6oX54hFu5baASKceHkudyVnN+v9NZmjX1BtIRLCdQ6fiqVPidDYKPF0i3cA7/8jm HDfkJWoJBioMpOH0lyjzkK376rcYvj0Afk+GXqVIQV2QdtAkSj26WKuY9tcSEgjxwobYFL5ROSGxt odQePDEd9/UPAY/FfFeBDm9ijcQjK1BqZNL5UbY2sc6AcbjBgB3exRmr7dkr5a2UHK+DmTuVVzIFB UT0LOpmV5dwflr99J0Uv0d3mMF86pKfaE77IrgVD0ksEkFaM/9Tzal8qyGWJ5lCX1+u8Bi1b3cmRH Szvm0PRA==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mzH2O-0007j4-8F for pgsql-docs@lists.postgresql.org; Mon, 20 Dec 2021 11:41:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mzH2M-00028B-7d for pgsql-docs@lists.postgresql.org; Mon, 20 Dec 2021 11:41:02 +0000 Content-Type: multipart/mixed; boundary="===============7388294045843269661==" MIME-Version: 1.0 Subject: Unnest discards rows with empty or null arrays To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: magnus.falch@gmail.com Reply-To: magnus.falch@gmail.com, pgsql-docs@lists.postgresql.org Date: Mon, 20 Dec 2021 11:40:47 +0000 Message-ID: <164000044713.26048.13078806558253708431@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7388294045843269661== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xNC9mdW5j dGlvbnMtc3JmLmh0bWwKRGVzY3JpcHRpb246CgpodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9t ZXNzYWdlLWlkLzE3MzQwLTc0ZDE3YmJlOTRjYjQxOTAlNDBwb3N0Z3Jlc3FsLm9yZw0KDQpUaGlz IGJlaGF2aW91ciBpcyB1bmV4cGVjdGVkIGZyb20gYW4gZXh0ZXJuYWwgcGVyc3BlY3RpdmUgYnV0 IGFmdGVyIHNwZWFraW5nCndpdGggZGVwZXN6IEkgY2FuIHNlZSB0aGUgZXhhY3QgZWRnZSBjYXNl IGl0J3MgZ3VhcmRpbmcgYWdhaW5zdC4NClJldHVybmluZyByb3dzIHdpdGggbnVsbCB2YWx1ZXMg d2hlbiB0aGUgZnVuY3Rpb24gZG9lcyBub3QgcmV0dXJuIGFueXRoaW5nLAp3b3VsZCBiZSBuYXR1 cmFsIGV4Y2VwdCBmb3IgdGhlIGZhY3QgdGhhdCBudWxsIGlzIGEgdmFsaWQgcmV0dXJuIHZhbHVl IGJ5Cml0c2VsZi4NCg0KRGlzY2FyZGluZyB0aGUgcm93IGlzIHByZWZlcmVudGlhbCB0byBnaXZp bmcgYW1iaWd1b3VzIGFuc3dlcnMgc2luY2UgaXQncyBhCnZlcnkgY2xlYXIgYW5zd2VyLg0KDQpJ IGNhbid0IHNlZSBpdCBtZW50aW9uZWQgYW55d2hlcmUgaW4gdGhlIGRvY3VtZW50YXRpb24gdGhv dWdoLgo= --===============7388294045843269661==--