| 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: | Whole Thread | Raw Message | 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 |