Re: unnest multirange, returned order

2023-10-13 Thread Daniel Fredouille
Hi, sorry it took me some time to reply. Yes, the patch is perfect if this is indeed the behavior. cheers Daniel Le jeu. 5 oct. 2023 à 02:50, Laurenz Albe a écrit : > On Wed, 2023-10-04 at 20:12 -0400, Daniel Fredouille wrote: > > unnest ( anymultirange ) → setof anyrange >

Re: unnest multirange, returned order

2023-10-04 Thread Daniel Fredouille
1,2) [3,4) """ Le mer. 4 oct. 2023 à 20:04, Daniel Fredouille a écrit : > Trying a suggestion then: > > """ > > unnest ( anymultirange ) → setof anyrange > > Expands a multirange into a set of ranges. The ranges are read out in > storage

Re: unnest multirange, returned order

2023-10-04 Thread Daniel Fredouille
""" Daniel Le mer. 4 oct. 2023 à 03:20, Laurenz Albe a écrit : > On Tue, 2023-10-03 at 20:40 -0400, Daniel Fredouille wrote: > > > I'd say that the storag order is the order in which PostgreSQL stores > > > multiranges internally: > > > > Right,

Re: unnest multirange, returned order

2023-10-03 Thread Daniel Fredouille
if order cannot be counted upon as it may evolve from postgres version to version, then let's make it clear as well. WDYT ? Thank you. Daniel Fredouille Le mar. 3 oct. 2023 à 09:46, Laurenz Albe a écrit : > On Mon, 2023-10-02 at 18:42 +, PG Doc comments form wrote: > > Page: h