| 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: | Whole Thread | Raw Message | 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?
| 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 |