Re: unnest multirange, returned order - Mailing list pgsql-docs

From Laurenz Albe
Subject Re: unnest multirange, returned order
Date
Msg-id fd85a22502ce44458bc3ddc616bf352c077e67f4.camel@cybertec.at
Whole thread Raw
In response to Re: unnest multirange, returned order  (Daniel Fredouille <daniel.fredouille@gmail.com>)
Responses Re: unnest multirange, returned order
List pgsql-docs
On Wed, 2023-10-04 at 20:12 -0400, Daniel Fredouille wrote:
> unnest ( anymultirange ) → setof anyrange
> Expands a multirange into a set of ranges. The ranges are read out in storage order (ascending) and therefore order
cannot berelied upon. 

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

Attachment

pgsql-docs by date:

Previous
From: Erik Wienhold
Date:
Subject: Re: Unclear guarantees about sort order on https://www.postgresql.org/docs/current/queries-order.html
Next
From: PG Doc comments form
Date:
Subject: This is too implicit that recovery.signal will be removed