On Tue, 2013-06-11 at 14:05 -0700, Joe Van Dyk wrote:
> # select tsrange(null)::tstzrange;
> ERROR: cannot cast type tsrange to tstzrange
> LINE 1: select tsrange(null)::tstzrange;
>
I agree that there should be a cast between tsrange and tstzrange.
Unfortunately, this cant work generally for all range types, because the
total order might be different. For instance, we can't cast between a
textrange and int4range, because:
['09','1']
is a valid text range, but:
[9,1]
is not.
Regards,
Jeff Davis