Re: Why is NULL not indexable?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Why is NULL not indexable?
Дата
Msg-id 24411.993742278@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Why is NULL not indexable?  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
Martijn van Oosterhout <kleptog@svana.org> writes:
> You'd want to add two more strategies to represent the relationsationships.
> This is not going to be quick, that's for sure.

Yeah, it would be really tedious to do it that way, because pg_amop
entries would need to be added for every indexable datatype.  This
wouldn't bother me so much for built-in datatypes, but it would also
break user-defined types that have index support --- indexing would
fail until they added entries too.

Since there isn't any real need for datatype-specific handling of NULL
searches, I'd be inclined to special-case them somehow without adding
explicit strategy numbers for them.  Not sure what it would take to
do this, though.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Alex Pilosov
Дата:
Сообщение: Re: Re: Red Hat to support PostgreSQL
Следующее
От: caldodge@fpcc.net (Calvin Dodge)
Дата:
Сообщение: Re: useability of apache, PHP, Postgres for real business apps