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 по дате отправления
От: Tatsuo Ishii
Дата: