Re: Query plan for NOT IN - Mailing list pgsql-performance

From Guy Rouillier
Subject Re: Query plan for NOT IN
Date
Msg-id 4ACA4A69.3010507@burntmail.com
Whole thread Raw
In response to Re: Query plan for NOT IN  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Responses Re: Query plan for NOT IN  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-performance
Grzegorz Jaśkiewicz wrote:
>
> well, as a rule of thumb - unless you can't think of a default value of
> column - don't use nulls. So using nulls as default 'idunno' - is a bad
> practice, but everybody's opinion on that differ.

I don't understand this point of view.  The concept of null was
introduced into the SQL vernacular by Codd and Date expressly to
represent unknown values.

--
Guy Rouillier

pgsql-performance by date:

Previous
From: Viji V Nair
Date:
Subject: Distributed/Parallel Computing
Next
From: Karl Denninger
Date:
Subject: Re: Best suiting OS