Re: casting between range types - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: casting between range types
Date
Msg-id 1314803355.7281.3.camel@jdavis
Whole thread Raw
In response to Re: casting between range types  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: casting between range types
List 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 by date:

Previous
From: Joe Abbate
Date:
Subject: Re: Comparing two PostgreSQL databases -- order of pg_dump output
Next
From: Andrew Dunstan
Date:
Subject: rename index fields bug