Re: WIP: RangeTypes

Поиск
Список
Период
Сортировка
Искать
От
Jeff Davis
Тема
Re: WIP: RangeTypes
Дата
Msg-id
1296427921.11513.628.camel@jdavis
Ответ на
WIP: RangeTypes (Jeff Davis)
Список
Дерево обсуждения
Re: WIP: RangeTypes Chris Browne <cbbrowne@acm.org>
Re: WIP: RangeTypes Jeff Davis <pgsql@j-davis.com>
Another updated patch.

Improvements:

  * Full GiST support
    - Thanks to Alexander Korotkov for sending me a new picksplit
algorithm for my "temporal" project on pgfoundry. I modified it for use
with range types, including a (hopefully) intelligent way of handling
empty and unbounded ranges.

  * Quite a few tests added, some cleanup done

Open items:

  * naming issues:
    - period -> tsrange ?
    - periodtz -> tstzrange ?
    - intrange -> int4range
  * add int8range
  * Documentation improvements
    - CREATE TYPE
    - ANYRANGE
    - Data Types section
  * Thom Brown and Tom Lane pointed out that the type inferencing
    should be able to promote int4 to numeric for queries like:
      select '[18,20]'::numrange @> 19;
  * Should the SQL function length(), which relies on polymorphic "-",
    be marked immutable, stable, or volatile?
  * representation or alignment issues
  * parser should be improved to handle spaces and quoting better
  * Should btree_gist be pulled into core to make it easier to use 
    exclusion constraints with range types?
  * Typmod (optional)

Regards,
	Jeff Davis
В списке pgsql-hackers по дате отправления
От: Noah Misch
Дата:
От: Tatsuo Ishii
Дата:
FAQ