Postgres Pro
Downloads
Home   >   mailing lists

casting tsrange to tstzrange doesn't seem to work? - Mailing list pgsql-general

From Joe Van Dyk
Subject casting tsrange to tstzrange doesn't seem to work?
Date
Msg-id CACfv+pLEuLZB4sbFdYvP=V0NvkKBYq6N4y0WH_vKRhTR=KDn-A@mail.gmail.com
Whole thread Raw
Responses Re: casting tsrange to tstzrange doesn't seem to work?  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
Tree view
# 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.

pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: INSERT RETURNING with values other than inserted ones.
Next
From: Don Parris
Date:
Subject: PostgreSQL Presentation at SELF 2013