Re: casting tsrange to tstzrange doesn't seem to work?

From: Joe Van Dyk <joe(at)tanga(dot)com>
To:
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: casting tsrange to tstzrange doesn't seem to work?
Date: 2013-07-26 07:16:31
Message-ID: CACfv+pLNy=NSWa_KOGunyWgo8wvho4fhgQZLQ8W10kAP4Eawtw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday, July 5, 2013, Jeff Davis wrote:

> 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
>

Worth it to file a bug for this?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Amit Langote 2013-07-26 07:26:15 Re: How to do incremental / differential backup every hour in Postgres 9.1?
Previous Message Andres Freund 2013-07-26 06:54:42 Re: Speed up Switchover