Tom Lane wrote:
> Hannu Krosing <[EMAIL PROTECTED]> writes:
> > How hard would it be to _not_ include nulls in indexes
> > as they are not used anyway.
>
> Seems to me that would be a step backwards.
It would cause multi-key indexes beeing unusable for partial
key lookup. Imagine you have a key over (a, b, c) and query
with WHERE a = 1 AND b = 2. This query cannot use the index
if a NULL value in c would cause the index entry to be
suppressed.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== [EMAIL PROTECTED] #
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
