Message-ID: <fd85a22502ce44458bc3ddc616bf352c077e67f4.camel@cybertec.at>
Subject: Re: unnest multirange, returned order
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Daniel Fredouille <daniel.fredouille@gmail.com>
Cc: pgsql-docs@lists.postgresql.org
Date: Thu, 05 Oct 2023 08:50:24 +0200
In-Reply-To: 
 <CAEpV6kWcAVFvmtw9amVubL7F9LWX==nE5N96uFrGm4XX6aFdVQ@mail.gmail.com>
References: 
	<169627213477.3727338.17653654241633692682@wrigleys.postgresql.org>
	 <2bad53942920d2e501661af4cd49d6644a22b801.camel@cybertec.at>
	 <CAEpV6kX9PJAuQ_=5c7ZxCSASu76hkvGfVvwU6WkHTRXzApknfQ@mail.gmail.com>
	 <47e801481db9947c4a597575ad45e1c6304130ca.camel@cybertec.at>
	 <CAEpV6kVJc7a3i86G5ifzn9hONxpbgvbP1g_xqidW3fMhTQ54yA@mail.gmail.com>
	 <CAEpV6kWcAVFvmtw9amVubL7F9LWX==nE5N96uFrGm4XX6aFdVQ@mail.gmail.com>
Content-Type: multipart/mixed; boundary="=-Hp72KQ+i/2YuVDIks541"
User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/fd85a22502ce44458bc3ddc616bf352c077e67f4.camel%40cybertec.at>
Precedence: bulk

--=-Hp72KQ+i/2YuVDIks541
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, 2023-10-04 at 20:12 -0400, Daniel Fredouille wrote:
> unnest=C2=A0(=C2=A0anymultirange=C2=A0) =E2=86=92=C2=A0setof anyrange
> Expands a multirange into a set of ranges. The ranges are read out in sto=
rage order (ascending) and therefore order cannot=C2=A0be relied=C2=A0upon.

That's not true.  The order is deterministic and can be relied on.

How about the attached patch, which does away with the confusing
mention of "storage order"?

Yours,
Laurenz Albe

--=-Hp72KQ+i/2YuVDIks541
Content-Disposition: attachment;
	filename="0001-Clarify-the-result-order-of-unnest-multirange.patch"
Content-Transfer-Encoding: base64
Content-Type: text/x-patch;
	name="0001-Clarify-the-result-order-of-unnest-multirange.patch";
	charset="UTF-8"

RnJvbSBlMzlkMWI1NzYwZDZmYTBlZDE0M2MxMzU4OWY3MTc4NDZjYzgyNTc0IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h
dD4KRGF0ZTogVGh1LCA1IE9jdCAyMDIzIDA4OjQ4OjIxICswMjAwClN1YmplY3Q6IFtQQVRDSF0g
Q2xhcmlmeSB0aGUgcmVzdWx0IG9yZGVyIG9mIHVubmVzdChtdWx0aXJhbmdlKQoKSXQgaXMgYmVz
dCBub3QgdG8gbWVudGlvbiB0aGUgc3RvcmFnZSBvcmRlciwgYmVjYXVzZSB0aGF0IGlzCmFuIGlt
cGxlbWVudGF0aW9uIGRldGFpbCBhbmQgaGFzIGNvbmZ1c2VkIGF0IGxlYXN0IG9uZSB1c2VyLAp3
aG8gYXNzdW1lZCB0aGF0IHRoZSBzdG9yYWdlIG9yZGVyIGlzIHRoZSBvcmRlciBpbiB3aGljaCB0
aGUKY29uc3RpdHVlbnQgcmFuZ2VzIHdlcmUgd3JpdHRlbiBpbiBTUUwuCgpTaW5jZSB0aGUgc29y
dGluZyBvcmRlciBpcyBleHBsYWluZWQgYXQgdGhlIGJlZ2lubmluZyBvZiB0aGUKcGFnZSwgaXQg
c2hvdWxkIGJlIHN1ZmZpY2llbnQgdG8gc2F5IHRoYXQgdGhlIHJhbmdlcyBhcmUKcmV0dXJuZWQg
aW4gYXNjZW5kaW5nIG9yZGVyLgoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8xNjk2
MjcyMTM0NzcuMzcyNzMzOC4xNzY1MzY1NDI0MTYzMzY5MjY4MiU0MHdyaWdsZXlzLnBvc3RncmVz
cWwub3JnCi0tLQogZG9jL3NyYy9zZ21sL2Z1bmMuc2dtbCB8IDIgKy0KIDEgZmlsZSBjaGFuZ2Vk
LCAxIGluc2VydGlvbigrKSwgMSBkZWxldGlvbigtKQoKZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dt
bC9mdW5jLnNnbWwgYi9kb2Mvc3JjL3NnbWwvZnVuYy5zZ21sCmluZGV4IDI0YWQ4N2Y5MTAuLmJi
YjZlODc4YWIgMTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9mdW5jLnNnbWwKKysrIGIvZG9jL3Ny
Yy9zZ21sL2Z1bmMuc2dtbApAQCAtMjAxMjEsNyArMjAxMjEsNyBAQCBTRUxFQ1QgTlVMTElGKHZh
bHVlLCAnKG5vbmUpJykgLi4uCiAgICAgICAgPC9wYXJhPgogICAgICAgIDxwYXJhPgogICAgICAg
ICBFeHBhbmRzIGEgbXVsdGlyYW5nZSBpbnRvIGEgc2V0IG9mIHJhbmdlcy4KLSAgICAgICAgVGhl
IHJhbmdlcyBhcmUgcmVhZCBvdXQgaW4gc3RvcmFnZSBvcmRlciAoYXNjZW5kaW5nKS4KKyAgICAg
ICAgVGhlIHJhbmdlcyBhcmUgcmVhZCBvdXQgaW4gYXNjZW5kaW5nIG9yZGVyLgogICAgICAgIDwv
cGFyYT4KICAgICAgICA8cGFyYT4KICAgICAgICAgPGxpdGVyYWw+dW5uZXN0KCd7WzEsMiksIFsz
LDQpfSc6OmludDRtdWx0aXJhbmdlKTwvbGl0ZXJhbD4KLS0gCjIuNDEuMAoK


--=-Hp72KQ+i/2YuVDIks541--