Re: IN clause

From: Jim Nasby <decibel(at)decibel(dot)org>
To: Marcus Engene <mengpg(at)engene(dot)se>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: IN clause
Date: 2006-11-27 23:24:31
Message-ID: 8DD97979-FA65-4234-B720-21FE6D006BBB@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Nov 24, 2006, at 9:04 AM, Marcus Engene wrote:
> There is one other case where I personally find nullable
> columns a good thing: process_me ish flags. When a row
> is not supposed to be processed that field is null and
> when a field is null it wont be in the index [at least
> on Oracle].

Actually, that's abuse of NULL. NULL is supposed to mean "I don't know".

In any case, like Oracle, PostgreSQL does not index NULL values (at
least not in btree).
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Responses

  • Re: IN clause at 2006-11-28 14:01:55 from Martijn van Oosterhout

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2006-11-27 23:25:41 Re: IS it a good practice to use SERIAL as Primary Key?
Previous Message Jim Nasby 2006-11-27 23:19:02 Re: Why overlaps is not working