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.98.2) (envelope-from ) id 1xQWJv-00000000BWw-2fKv for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Nov 2026 20:50:27 +0000 Received: from localhost ([127.0.0.1]:59264 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xQWJu-00000002Xlz-0H1K for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Nov 2026 20:50:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]:36996) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xQWJt-00000002Xlo-3EoC for pgsql-hackers@lists.postgresql.org; Mon, 09 Nov 2026 20:50:26 +0000 Received: from mail-oa1-x35.google.com ([2001:4860:4864:20::35]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xQWJt-000000005Xn-04PL for pgsql-hackers@lists.postgresql.org; Mon, 09 Nov 2026 20:50:25 +0000 Received: by mail-oa1-x35.google.com with SMTP id 586e51a60fabf-48ed188ee81so654187fac.1 for ; Mon, 09 Nov 2026 12:50:24 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20260707; t=1794257424; x=1794862224; darn=lists.postgresql.org; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:from:to:cc:subject :date:message-id:reply-to:content-type; bh=FQ6DQTZcrn4Ns/O1zusHlOpKUmDF4qUN7uzaFjN4Is8=; b=khYprbYK2tUj2B9ICB6Th0HmFtNZcimLxwWjvosl8lPQYysEbdvi0JAICcSoW3BfQZ ARyFZuukERRxBzNdJjFZK7M6vjCgkBqDnnavb7BHM4sf+A1wqcra3JvzHsepiFoTQsE2 qj7+BIdWbxxXKuEG8bhWtm/wRNqLPcK4btuQItKvifkKrDwGDpQ82/0pAhmsqW56ia12 IEOFv6kHG/Y4+WWPl+xIHH/36lturJ8vO3h/+oHFKOOZiJkpNT5oPlyNG8sEm5t/cNHD 0aN+hN2S60/qJfdM/3rX1ZiYU+E4+zqmhPREjCLmvvveQnwYOwdYmDkC51VFuiMIaz0u rPVg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1794257424; x=1794862224; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=FQ6DQTZcrn4Ns/O1zusHlOpKUmDF4qUN7uzaFjN4Is8=; b=hsruc4KiQA8YJYj4cW8RrIiXPuCtYH66FvCippR/RM1k0tDcNY5apGN6r+151Mz5c2 KBgq46H+3T6rnb+3QJYmRUDm1a5iOHuJ/BmWYvui0W8kHk8cEbiItlk8XKSeYIXbHWRc XdAQ3Ri2wCKoV42wNMSYc4mh1o+Yf/PhBgQ4J5wKtpOWRQOhG3AOtzoEg3JVfdQvZHC1 kBRZOtRxHiYR8mXKPJv0wP9zWa0QxqfThkZdEA1yFX2xkzxG/jHGe/UKLgsGaNUhx8pE MuvlcgVxMIe3iWZQnngX4AXufgq4BYAvcoOUP6ExX3uUrAVECIw2uvf7Y3CfVs/bUpco ZnHA== X-Forwarded-Encrypted: i=1; AL+hErGlGqOHsEI27BgKd1/C0r5vNntkwfSeXBU3nMwsyyYIWMNUSVqTmLjZdelTZjRiPtk15Lc0aq5Ga+EtAgQs@lists.postgresql.org X-Gm-Message-State: APuU4Z8eTBNj+PubYGbqDEe/szsWTbDxDnlZL4DQI9iiZ6XBQ4+XftdP WXefjOViRTENUgQCBey6+2kiPgPVeE/PtddYFWCLf1Cfg4ItU8MZRIXr X-Gm-Gg: AYBFou0QFcd+yzD0lHGrlep1h2H/1c02aIfp537+NmXv8N3TOnpgUmLFwc2kgrr2h5u wbjbIz3L7DtATMDHKpL1dUvwpm62P5lq2F44yqmmVHvCNYutW7WyaK9CvZ3CVlKehKGkLDZGfX8 woqueg+sL1U7+YOJspL/mH2xaX52ging0u7s1+dsUgfMucEsfur38KBLemggUFlzn9PXECL9K/L /FDL/NjluPog1s796ehlvvRfocIG/buWPy/8H6sf6svLdOv8uV9wLVdSNarsdOc7dtFBz4BHFct G2qESVguxDdEzyQ2JC9yGRytxjtKjz+XGFop8iJKDGlRH8WKl7NQ/7HFDC6it5+grUSeNPZ1889 SW5axG3BGx80HXp4iOHlsRBsjvl5fbSBf5JGA/iIVIkBABTu/J5epPRfrycrMJvdFSfkSNJCjMb ACgS9ymQKHUGIsEoslnrXlBH4X4qprWXkM9SsQDelLsRIC5GLRuUCVIWtkw1fUNdMFExrVkMsxX F7OJOPlvfT00lkbR8hCipGWqU1A24cgRCD50krsxoB3U1ziF/FPVaUfvRXZCW0AJ1dRtO4bS38U 69dG2ib7OCI+x9MOXIPn6TZ2WXPd2GSsBl72Nw9KKm4iMOOMkwhvjLa4SaWgYrtbbazuJ3oHGhn FwxL0AcIX7z1hkVBPJxXlLK/qgoeIqa3/4Mu0zlhANDPLhWEj5a5O4h8= X-Received: by 2002:a05:6870:e243:b0:492:1de3:785f with SMTP id 586e51a60fabf-4ae227dbe95mr231966fac.46.1794257423701; Mon, 09 Nov 2026 12:50:23 -0800 (PST) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 586e51a60fabf-4ae22fbc9c5sm178570fac.9.2026.11.09.12.50.22 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 09 Nov 2026 12:50:23 -0800 (PST) Date: Mon, 9 Nov 2026 14:50:21 -0600 From: Nathan Bossart To: Vik Fearing Cc: Zsolt Parragi , pgsql-hackers@lists.postgresql.org, Jacob Champion , Isaac Morland Subject: Re: Logical Implication Message-ID: References: <9ab35dbb-d9a4-4c1e-bae2-7763ddeb720c@postgresfriends.org> <3d779ee0-6596-4dae-b79c-e35b237f83bf@postgresfriends.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Nov 06, 2026 at 02:05:23PM -0600, Nathan Bossart wrote: > On Tue, Oct 06, 2026 at 01:19:31PM -0500, Nathan Bossart wrote: >> On Sat, Oct 03, 2026 at 06:18:43PM +0200, Vik Fearing wrote: >>> SQL uses a three-valued logic system with true, >>> - false, and null, which represents unknown. >>> - Observe the following truth tables: >>> + false, and unknown; the null value of a boolean and the truth >>> + value unknown are one and the same. In the truth tables below the left >>> + operand of a binary operator selects the row, and the right operand the >>> + column: >> >> I find the reorganization to be an improvement, and I intend to commit this >> one sooner than later. The only thing I'd change is the switch from NULL >> to "unknown" in the tables. Users deal with NULL at the command level, and >> the rest of the docs use NULL, so I think the existing text has the right >> idea by noting once that NULL represents "unknown" and then using NULL >> throughout. > > Concretely, like the attached. I've committed this one. -- nathan