Re: SET within a function?

From: Mike Mascari <mascarm(at)mascari(dot)com>
To: Edmund Dengler <edmundd(at)eSentire(dot)com>
Cc: Arthur Ward <award(at)dominionsciences(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: SET within a function?
Date: 2003-10-14 16:59:01
Message-ID: 3F8C2B55.8020005@mascari.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Edmund Dengler wrote:

> The problem I would face is that this still needs to be a sequential scan
> in the table rather than an index lookup.

IIRC, NULL values aren't indexed, only actual values, which is an
implementation detail but yet-another reason why NULL-elimination
through normalization is a good idea:

http://www.hughdarwen.freeola.com/TheThirdManifesto.web/Missing-info-without-nulls.pdf

Mike Mascari
mascarm(at)mascari(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lamar Owen 2003-10-14 17:15:18 Re: Redhat RPMs
Previous Message pw 2003-10-14 16:54:44 converting varchar date strings to date