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.
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 |