Re: Problem with CAST-ing - am I missing something?

[Christophe Pettus <xof@xxxxxxxxxxxx>]

> On Oct 25, 2023, at 17:21, Pól Ua Laoínecháin <linehanp@xxxxxx> wrote:
> 
> SELECT (ts, te)::TSTZRANGE FROM test;

That syntax doesn't mean what you probably think it does.  (ts, te) defines a record type with two fields.  PostgreSQL constructs that, and then attempts to apply the cast.  There's no conversion path from that to TSTZRANGE, so the system complains.  It's imaginable, I guess, that such a path could be added, but the right way to do it is what you do here:

> SELECT TSTZRANGE(ts, te) FROM test;