Re: WIP: RangeTypes
От | Jeff Davis |
---|---|
Тема | Re: WIP: RangeTypes |
Дата | |
Msg-id | 1296427921.11513.628.camel@jdavis обсуждение исходный текст |
Ответ на | WIP: RangeTypes (Jeff Davis <pgsql@j-davis.com>) |
Ответы |
Re: WIP: RangeTypes
|
Список | pgsql-hackers |
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 по дате отправления: