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 1s9VZX-002pLh-9K for pgsql-hackers@arkaria.postgresql.org; Tue, 21 May 2024 19:54:56 +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 1s9VZW-00CMer-5D for pgsql-hackers@arkaria.postgresql.org; Tue, 21 May 2024 19:54:54 +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 1s9VZV-00CMei-OK for pgsql-hackers@lists.postgresql.org; Tue, 21 May 2024 19:54:53 +0000 Received: from mail-pf1-x432.google.com ([2607:f8b0:4864:20::432]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s9VZS-001L9a-6b for pgsql-hackers@lists.postgresql.org; Tue, 21 May 2024 19:54:52 +0000 Received: by mail-pf1-x432.google.com with SMTP id d2e1a72fcca58-6f6b1ac1e90so128576b3a.1 for ; Tue, 21 May 2024 12:54:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1716321289; x=1716926089; 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=OZj14udcuckut3rUNgxpp92MMEDgl7bnOoIlQ0mVl/U=; b=hFDYa2xpafzZeNv3Q+qYBa2qg1+Dbdx055hJbsfff0fK0fnHBe62ffPpVJwcVlFkZy LMTpj5ZHft54hllnspPuIZDyB8fs1fgs5xUjnH1Mn9bORxfEr0wJFI+cS31eGfHsXhCX MJUN8ceXIyIOstXqofwmKvRB0YJCyt0ddkgX7yvTLxAhAihg6OMA6YkGixP15aA0G9bD uNmViO0h1fZ25wi/X69ss2BbCgq6Ng1bwFl4APv3A29muYh0lHUg7/+8P6e6XfjpZDF4 4cgOGLGaEBfF5+yCaBUHHqxcf8zNUNvkyJPsw45dz6TX1VirsPLCzZLgdp14DASIdlJQ nW8Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1716321289; x=1716926089; 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=OZj14udcuckut3rUNgxpp92MMEDgl7bnOoIlQ0mVl/U=; b=gQTY16TSMcwG52PW2gq6gc2em1iDUbgW3ROzINveNu6xM/e2mJ7EWiw8DAKM+k5J9t n7V/lsFHur6UloiBPIIbVGRpZr9ZQgumGZ47teIt/q1KkUIRpr/dVUwvD010KuDqfhf6 9kLmYDkYrfIfwcrT2SjVOSsV9lEs2+WGWNbsPV0yI/7d3fAYNj5A3taGP7L+A27n2H9n erLpkrJ95M9c8OUC2En0KKqk94swNatV2+T4UdUAl7mgr9RLmR3BDytmUMreAF1RCIT/ FH6+X+9LxdXjrzvv97zvGCeA4yKzMdAzEiYwXc9DbQM/XMNZs6jyuOuf1B9Ehzx2tuuv oXSg== X-Forwarded-Encrypted: i=1; AJvYcCU5BckoZp5iGfscA7e2zV1izxM5ycuo6bf9rAJcH1NmyKXSOka8jHYVe3Y0CV169TlHIH4CoNuab5k8MDYuzpikckKSrzVH8/vU0oIP+BOoVdAf X-Gm-Message-State: AOJu0YyRRPC4rP8TZVC4rZ6VLO8xZJUXLQgRMB01oYuHaj50GQ5ZzH61 TWVhbycxbDXnGjyx7oX8d4FNou0vtum30U+xwgHntKRTffgVTQlPG42A42QfWA== X-Google-Smtp-Source: AGHT+IHQcr5kFL2xOOGIoNc89I6Gp3gG4haG2ucqHnOIQkgaBpncQWVyO5a200jiGUY2IJMVjyK+Sw== X-Received: by 2002:a05:6a00:2e02:b0:6f4:9fc7:d239 with SMTP id d2e1a72fcca58-6f69fc6d156mr17373214b3a.14.1716321289160; Tue, 21 May 2024 12:54:49 -0700 (PDT) Received: from [172.18.10.46] ([12.126.244.130]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-6f67a100ff9sm10902271b3a.142.2024.05.21.12.54.48 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 21 May 2024 12:54:48 -0700 (PDT) Message-ID: Subject: Re: SQL:2011 application time From: Jeff Davis To: Robert Haas Cc: Peter Eisentraut , Paul Jungwirth , jian he , PostgreSQL Hackers Date: Tue, 21 May 2024 12:54:47 -0700 In-Reply-To: References: <85dd3ad0-fa79-46e8-a08b-c426c76825f3@eisentraut.org> <49c07eac-18ec-4aff-929c-e81b87df1092@eisentraut.org> <1edb3b79-a4bc-43b1-80aa-2e090472fe32@eisentraut.org> <47550967-260b-4180-9791-b224859fe63e@illuminatedcomputing.com> <64c2b2ab-7ce9-475e-ac59-3bfec528bada@eisentraut.org> <58b6687fe9de002e4c862a412719e4f918bad987.camel@j-davis.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2024-05-21 at 13:57 -0400, Robert Haas wrote: > What I think is less clear is what that means for temporal primary > keys. Right. My message was specifically a response to the concern that there was some kind of design flaw in the range types or exclusion constraints mechanisms. I don't believe that empty ranges represent a design flaw. If they don't make sense for temporal constraints, then temporal constraints should forbid them. Regards, Jeff Davis