Re: Time range - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Time range
Date
Msg-id 49291.1559329257@sss.pgh.pa.us
Whole thread Raw
In response to Re: Time range  (Isaac Morland <isaac.morland@gmail.com>)
List pgsql-hackers
Isaac Morland <isaac.morland@gmail.com> writes:
> Given that other built-in types have built-in range types, I think that the
> time and timetz types should also have built-in range types.

There's only a very small number of built-in range types:

postgres=# select typname from pg_type where typtype = 'r' order by 1;
  typname  
-----------
 daterange
 int4range
 int8range
 numrange
 tsrange
 tstzrange
(6 rows)

I don't think there's any appetite for creating built-in range types
across-the-board.  The time and timetz types are pretty little used
(with good reason), so leaving them out of this list seems fine to me.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Isaac Morland
Date:
Subject: Re: Time range
Next
From: David Rowley
Date:
Subject: Re: using index or check in ALTER TABLE SET NOT NULL