pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Nathan Bossart <nathandbossart@gmail.com>
To: Vik Fearing <vik@postgresfriends.org>
Cc: Zsolt Parragi <zsolt.parragi@percona.com>
Cc: pgsql-hackers@lists.postgresql.org, Jacob Champion <jacob.champion@enterprisedb.com>
Cc: Isaac Morland <isaac.morland@gmail.com>
Subject: Re: Logical Implication
Date: Mon, 9 Nov 2026 14:50:21 -0600
Message-ID: <avIyDcgAN1YufY1U@nathan> (raw)
In-Reply-To: <au4zAwo3wQ-KfOh-@nathan>
References: <aqQL78v7jr0AED_b@nathan>
	<b0edbd8b-66e5-44c0-9b90-516760df1209@postgresfriends.org>
	<arU0qXcp3KSj7M-g@nathan>
	<9ab35dbb-d9a4-4c1e-bae2-7763ddeb720c@postgresfriends.org>
	<CAN4CZFPUmkNyYP=MJbCE3OC21-De9AYhJXOD_wd8Q06E6xBzqQ@mail.gmail.com>
	<3d779ee0-6596-4dae-b79c-e35b237f83bf@postgresfriends.org>
	<ar0mGmQQz6vI6pts@nathan>
	<b70aba34-e799-4c09-aa3e-281a335ebf2f@postgresfriends.org>
	<asU7s4y_QzU7yJVZ@nathan>
	<au4zAwo3wQ-KfOh-@nathan>

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:
>>>      <acronym>SQL</acronym> uses a three-valued logic system with true,
>>> -    false, and <literal>null</literal>, which represents <quote>unknown</quote>.
>>> -    Observe the following truth tables:
>>> +    false, and unknown; the null value of a <type>boolean</type> 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






view thread (22+ messages)  latest in thread

Message-ID: <avIyDcgAN1YufY1U@nathan>
Permalink:  ../avIyDcgAN1YufY1U@nathan/
Also on:    postgresql.org/message-id/avIyDcgAN1YufY1U@nathan

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-hackers@postgresql.org
  Cc: nathandbossart@gmail.com, vik@postgresfriends.org, zsolt.parragi@percona.com, jacob.champion@enterprisedb.com, isaac.morland@gmail.com
  Subject: Re: Logical Implication
  In-Reply-To: <avIyDcgAN1YufY1U@nathan>
  References: <aqQL78v7jr0AED_b@nathan> <b0edbd8b-66e5-44c0-9b90-516760df1209@postgresfriends.org> <arU0qXcp3KSj7M-g@nathan> <9ab35dbb-d9a4-4c1e-bae2-7763ddeb720c@postgresfriends.org> <CAN4CZFPUmkNyYP=MJbCE3OC21-De9AYhJXOD_wd8Q06E6xBzqQ@mail.gmail.com> <3d779ee0-6596-4dae-b79c-e35b237f83bf@postgresfriends.org> <ar0mGmQQz6vI6pts@nathan> <b70aba34-e799-4c09-aa3e-281a335ebf2f@postgresfriends.org> <asU7s4y_QzU7yJVZ@nathan> <au4zAwo3wQ-KfOh-@nathan> <avIyDcgAN1YufY1U@nathan>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox