Re: Query plan for NOT IN

From: Guy Rouillier <guyr-ml1(at)burntmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query plan for NOT IN
Date: 2009-10-05 19:35:05
Message-ID: 4ACA4A69.3010507@burntmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Karl Denninger 2009-10-05 19:39:54 Re: Best suiting OS
Previous Message Viji V Nair 2009-10-05 19:11:07 Distributed/Parallel Computing