Isaac Morland 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;
timetzrange is also missing. In my database I have:
CREATE TYPE timerange AS RANGE (SUBTYPE = time);
COMMENT ON TYPE timerange IS 'range of times without time zone';
GRANT USAGE ON TYPE timerange TO PUBLIC;
CREATE TYPE timetzrange AS RANGE (SUBTYPE = timetz);
COMMENT ON TYPE timetzrange IS
Donald Shtjefni schrieb am 31.05.2019 um 13:35:
> I was wondering why there is not a type Range of time without time zone, I
> think it may be useful for someone, Is good if i do PR.
you can easily create one:
create type timerange as range (subtype = time);
Thomas
On Fri, May 31, 2019 at 08:35:31AM +0200, Donald Shtjefni wrote:
Hi,
I was wondering why there is not a type Range of time without time zone, I
think it may be useful for someone, Is good if i do PR.
Sorry if I've worte in the wrong place
Doesn't tsrange already do that? That's a timestamp
Hi,
I was wondering why there is not a type Range of time without time zone, I
think it may be useful for someone, Is good if i do PR.
Sorry if I've worte in the wrong place
