Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qnwBD-00CTMA-6a for pgsql-docs@arkaria.postgresql.org; Wed, 04 Oct 2023 07:20:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qnwBB-00D0JJ-M9 for pgsql-docs@arkaria.postgresql.org; Wed, 04 Oct 2023 07:20:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qnwBB-00D0Il-E7 for pgsql-docs@lists.postgresql.org; Wed, 04 Oct 2023 07:20:21 +0000 Received: from mail-lf1-x133.google.com ([2a00:1450:4864:20::133]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qnwB9-0086rn-F1 for pgsql-docs@lists.postgresql.org; Wed, 04 Oct 2023 07:20:20 +0000 Received: by mail-lf1-x133.google.com with SMTP id 2adb3069b0e04-50337b43ee6so2166434e87.3 for ; Wed, 04 Oct 2023 00:20:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1696404018; x=1697008818; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=E5nsQ4Z1LtLwu+0MbxL+Jb3WR7xY9IRUQlsfJMSLtro=; b=x7S9xAGizCX56+UI5YZwENet2+O2jEA2dVE0DWBlAlWXstAgJIW+UuuasrMXNR0+5q b7ZyfwoZsIDlOdxtOG3A260A5IOfuqPiC4FpH66XK59M2gSsuHHl0wL9fkBUCHOA3URe Pi8cXQnaSz2SLGf48qd2gnUf5fsEr1KeNq5N3hOL7iFCE1o/kVrZdV3gQf1UKNyrr4Fc 7SXmV9yySKaq5sIyB+v8IGT3sOi0vtuzXfUlcaLmZ6XBPLFDs+0eYKuhtkZ9b65FdX6R yvjo3qGR9kVvCrpSJkcKfxRQBHQHWj0ds5NFWeKDFu63nUi2Pk2Qb0ptND4h3gXMBxXV VCQA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1696404018; x=1697008818; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=E5nsQ4Z1LtLwu+0MbxL+Jb3WR7xY9IRUQlsfJMSLtro=; b=R3jPvzlr2J89HMqcrDwakWjyz9YgUoJpPa9DPdx/kLtCmX8xJXcx6JY3iEOVz9gLgu /pH/654OiG8AoXBKwQS5wrcVGULS1TCi2egyACpFC4G+FFv1U2hzjQOBKboGa/j60X+c QIljk9B42d/2VxYmeYisCxoTNKzTca3Fyd8Fj/WMZmaksd7CEawzJpLY6U7m9YgV/KDv KF2TJb7V60Eh9jTkbsNaCKuW9XOQ3jgnUntlLqDV277DKr72ovJLDaO1z0Q63x7iVW7r 3gApP7LRX6qK2KVEDgap0T2XzTw7zHOVGx0bNb7Sz03zh04G1F3uifbjNVweND2oJUIX N6SQ== X-Gm-Message-State: AOJu0Yxy7jMeuYtlGNv/IV+3gN4N8XgXO8/nEXtsUjE7SJhpU0f0Dxon MBSNT/JL+suzkVYbkMcYwN8EwA== X-Google-Smtp-Source: AGHT+IHi9lYM+JX15wnXhdVfesDhAkvgojPfaP1OKY+HLWQKvCUgwqFHwyy4UQPoaP16ZG/3bVc0bQ== X-Received: by 2002:a05:6512:3e25:b0:500:b64e:4f40 with SMTP id i37-20020a0565123e2500b00500b64e4f40mr1429820lfv.41.1696404017667; Wed, 04 Oct 2023 00:20:17 -0700 (PDT) Received: from localhost.localdomain ([88.116.133.170]) by smtp.gmail.com with ESMTPSA id i2-20020a05600c290200b00402f7b50517sm775682wmd.40.2023.10.04.00.20.17 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 04 Oct 2023 00:20:17 -0700 (PDT) Message-ID: <47e801481db9947c4a597575ad45e1c6304130ca.camel@cybertec.at> Subject: Re: unnest multirange, returned order From: Laurenz Albe To: Daniel Fredouille Cc: pgsql-docs@lists.postgresql.org Date: Wed, 04 Oct 2023 09:20:16 +0200 In-Reply-To: References: <169627213477.3727338.17653654241633692682@wrigleys.postgresql.org> <2bad53942920d2e501661af4cd49d6644a22b801.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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: >=20 > Right, I believe that you are right but then this information is not usef= ul for the developer.=C2=A0 > If storage order is always ascending by range order then let's make it cl= ear, > if order cannot be counted upon as it may evolve from postgres version to= version, > then let's make it clear as well. WDYT ? I personally think that it is clear as it is written now. If you have a good suggestion for an improvement, you could send it; perhaps someone will pick it up. Yours, Laurenz Albe