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 1s7kQs-007CXW-C1 for pgsql-hackers@arkaria.postgresql.org; Thu, 16 May 2024 23:22:43 +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 1s7kQr-000bcz-U4 for pgsql-hackers@arkaria.postgresql.org; Thu, 16 May 2024 23:22:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s7kQr-000bcr-K8 for pgsql-hackers@lists.postgresql.org; Thu, 16 May 2024 23:22:41 +0000 Received: from mail-pf1-x42c.google.com ([2607:f8b0:4864:20::42c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s7kQo-000cIw-9k for pgsql-hackers@lists.postgresql.org; Thu, 16 May 2024 23:22:40 +0000 Received: by mail-pf1-x42c.google.com with SMTP id d2e1a72fcca58-6f4178aec15so759734b3a.0 for ; Thu, 16 May 2024 16:22:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1715901757; x=1716506557; 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=F/3lVrh2IzIfxWarAesOFDSgQeWzLv9lzGtIOoh0nBU=; b=jg0SNyYNJtDniE/gaC78Po2JFTUd7AuDNZubd9vLSUKK1O+kTorxv9TULNVVGxUxur wlnm4Dq72TPOjGCI+z5u4/VWSHIjGwC85phaXrEiyZtDMuE+I/yyblWk+B7htnqGDsr3 aVcaWxLtOle/CELWVyvIjIoFmBEs3Sm+WOWzgqhoITGo/JRb+yDL+PSJXJb7/G1CWygk Z8C8ZhzofhiagNkRGjm4wEN7UXDwfI+wpnsfz+xXX4mUQvI/KQ1xbeeoqQ//kVjpeFwA uYQz+qhC24iMdo0GDZ0bLLepMIQbr/BMmNL+MoCHR6du6cv48M+iRlhAhQy4jx2VTjV3 2SKA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1715901757; x=1716506557; 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=F/3lVrh2IzIfxWarAesOFDSgQeWzLv9lzGtIOoh0nBU=; b=bve8GwtqnIwoNWWbLIZzG366ZffnT0RAfyWrIMwSP573/Zm9tWuO6fn/heJ8ub4XdG A+q685xC0E+xuywKdY5chqz95uLIwo2naQCgrJ9fx3WZ06ndQiLSKqYmYm8sMQsQ0GYZ PFozyGH6K/345qIkZzwaVDNrV+e43mWlkV0BAqOCnbPokD1nUMQBRXe63Q4IinxUdpL9 VTS30pUnezdZk3L/qgVXTytQJkYZ1GdAuLvYD2JdBY/VtVWvJODdWR1JqoWPvUkdFjfa 8qHGLvmPEYAxtNdfbEjJGRzqKshWyFdvYgLmWXBB9MuO+RwNJlXrnvx0quJZaNkHl2qt mP5w== X-Gm-Message-State: AOJu0Ywvn1EB3dEbpmudwEXnXkLoqs4m+ysl6rgfug7OfA5899NBXxmM AxyXax56ARClfpZlvSXLOUSKt/VJYFCRYjVqpCn5nYQyzeyMUT7mkZEAcc+nZQ== X-Google-Smtp-Source: AGHT+IF9YqQQwmZBUOvJpKiWjJvH/jazJ1aPZA/P6DfMfzorRrimWMD3QkfqZWNksS6TN6ZLp+zMbQ== X-Received: by 2002:a05:6a20:e607:b0:1af:fe9e:5e43 with SMTP id adf61e73a8af0-1affe9e608fmr10687663637.11.1715901756957; Thu, 16 May 2024 16:22:36 -0700 (PDT) Received: from [172.18.10.46] ([12.126.244.130]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-6f4d2af2c41sm14075716b3a.172.2024.05.16.16.22.36 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 16 May 2024 16:22:36 -0700 (PDT) Message-ID: <58b6687fe9de002e4c862a412719e4f918bad987.camel@j-davis.com> Subject: Re: SQL:2011 application time From: Jeff Davis To: Peter Eisentraut , Paul Jungwirth , jian he Cc: PostgreSQL Hackers Date: Thu, 16 May 2024 16:22:35 -0700 In-Reply-To: <64c2b2ab-7ce9-475e-ac59-3bfec528bada@eisentraut.org> 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> 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 Mon, 2024-05-13 at 12:11 +0200, Peter Eisentraut wrote: > Some of these issues might be design flaws in the underlying > mechanisms,=20 > like range types and exclusion constraints.=C2=A0 Like, if you're suppose= d > to=20 > use this for scheduling but you can use empty ranges to bypass > exclusion=20 > constraints, how is one supposed to use this? An empty range does not "bypass" the an exclusion constraint. The exclusion constraint has a documented meaning and it's enforced. Of course there are situations where an empty range doesn't make a lot of sense. For many domains zero doesn't make any sense, either. Consider receiving an email saying "thank you for purchasing 0 widgets!". Check constraints seem like a reasonable way to prevent those kinds of problems. Regards, Jeff Davis