casting tsrange to tstzrange doesn't seem to work?

From: Joe Van Dyk <joe(at)tanga(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: casting tsrange to tstzrange doesn't seem to work?
Date: 2013-06-11 21:05:11
Message-ID: CACfv+pLEuLZB4sbFdYvP=V0NvkKBYq6N4y0WH_vKRhTR=KDn-A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

# select tsrange(null)::tstzrange;
ERROR: cannot cast type tsrange to tstzrange
LINE 1: select tsrange(null)::tstzrange;

Is this expected?

select null::timestamp::timestamptz;
works fine.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Don Parris 2013-06-11 21:35:19 PostgreSQL Presentation at SELF 2013
Previous Message David Johnston 2013-06-11 15:15:31 Re: INSERT RETURNING with values other than inserted ones.