Why is NULL not indexable?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Why is NULL not indexable?
Date: 2001-06-26 14:05:41
Message-ID: 20010627000540.A7931@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm kinda of curious because if you look at
src/backend/access/nbtree/nbtree.c there are comments stating that you can
add NULLs to the index but mentions that you can't because:

"that's an artifact of the strategy map architecture chosen in 1986."

I can't work out what the 'strategy' bit refers to. All I can find in the
source code is references to tables of magic numbers. I guess what I really
want to know is, how hard would it be to fix?

(BTW, it seems there's an awful lot of duplicated code between all the index
types. Is this a historical accident or is there a reason?)

--
Martijn van Oosterhout <kleptog(at)svana(dot)org>
http://svana.org/kleptog/
- Artificial Intelligence is the science of making computers that behave
- like the ones in the movies.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Solianic 2001-06-26 14:10:09 Re: JDBC and SQL
Previous Message Gunnar Rønning 2001-06-26 12:52:50 Re: More Red Hat information