Re: Document NULL - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Document NULL
Date
Msg-id CAKFQuwYzChK7Y_XnU1QD-rJEOxML93DuR_z6tR69f7f=83i+kw@mail.gmail.com
Whole thread Raw
In response to Re: Document NULL  (Marcos Pegoraro <marcos@f10.com.br>)
List pgsql-hackers
On Wed, Dec 11, 2024 at 11:46 AM Marcos Pegoraro <marcos@f10.com.br> wrote:
Em ter., 10 de dez. de 2024 às 20:00, David G. Johnston <david.g.johnston@gmail.com> escreveu:

Section nullvalues-filtering you are showing filtering with equal and not equal. Wouldn't it be better if you show just one of them and the other using DISTINCT FROM, which would get different results ?


I'm demonstrating the sentence written there - 

A WHERE clause that evaluates to a null value for a given row will exclude that row.

While I can do that with a single example my intent here was to also show that if one writes seemingly mutually exclusive expressions in a where clause it is possible neither expression will find a row, in this case with id=2.  "p OR !p" again.  I'll give this some more thought though.

In any case I do need to add a few more words framing up the examples.  Probably pointing back to the cardinal rule sub-section.

David J.

pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: Track the amount of time waiting due to cost_delay
Next
From: Andres Freund
Date:
Subject: Re: Add Postgres module info