Re: casting between range types

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: casting between range types
Дата
Msg-id 1314803355.7281.3.camel@jdavis
обсуждение исходный текст
Ответ на Re: casting between range types  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: casting between range types  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
On Wed, 2011-08-31 at 09:20 +0300, Heikki Linnakangas wrote:
> On 31.08.2011 09:14, Jeff Davis wrote:
> > First, a range is really a set. So if we take '[1,10)'::int4range and
> > cast that to numrange, we end up moving from a set of exactly 9 elements
> > to a set of an infinite number of elements. Going the other way is
> > probably worse.

...

> Can you only provide casts that make sense, like between int4 and 
> numeric range types, and leave out the ones that don't?

There are certainly some casts that make sense, like
int4range->int8range. Do you think int4range->numrange also makes sense?

Regards,Jeff Davis



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

Предыдущее
От: Joe Abbate
Дата:
Сообщение: Re: Comparing two PostgreSQL databases -- order of pg_dump output
Следующее
От: Andrew Dunstan
Дата:
Сообщение: rename index fields bug