pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jeff Davis <jdavis@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Clarify the result order of unnest(multirange).
Date: Fri, 27 Oct 2023 23:06:47 +0000
Message-ID: <E1qwVuh-002gMH-DN@gemulon.postgresql.org> (raw)

Clarify the result order of unnest(multirange).

It is best not to mention the storage order, because that is
an implementation detail and has confused at least one user,
who assumed that the storage order is the order in which the
constituent ranges were written in SQL.

Since the sorting order is explained at the beginning of the
page, it should be sufficient to say that the ranges are
returned in ascending order.

Author: Laurenz Albe
Reviewed-by: Daniel Fredouille
Discussion: https://postgr.es/m/169627213477.3727338.17653654241633692682%40wrigleys.postgresql.org

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/d014e6cb188664d053cbed87130416617226b373

Modified Files
--------------
doc/src/sgml/func.sgml | 3 +--
1 file changed, 1 insertion(+), 2 deletions(-)



Message-ID: <E1qwVuh-002gMH-DN@gemulon.postgresql.org>
Permalink:  ../E1qwVuh-002gMH-DN@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1qwVuh-002gMH-DN@gemulon.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: jdavis@postgresql.org, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Clarify the result order of unnest(multirange).
  In-Reply-To: <E1qwVuh-002gMH-DN@gemulon.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox