Re: extended operator classes vs. type interfaces - Mailing list pgsql-hackers

From Nathan Boley
Subject Re: extended operator classes vs. type interfaces
Date
Msg-id u2p6fa3b6e21004091618re5ad35f5qdb83d009a8e2c62c@mail.gmail.com
Whole thread Raw
In response to Re: extended operator classes vs. type interfaces  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: extended operator classes vs. type interfaces  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
> The advantage of specifying a + and a - in the type interface is that
> the unit definition can then be specified as part of the type
> declaration itself.  So you can do:
>
> CREATE TYPE ts_sec AS RANGE OVER timestamp (UNIT = '1s');
> CREATE TYPE ts_min AS RANGE OVER timestamp (UNIT = '1m');
>
> All of the stuff about defining + and - is hidden from the user - it's
> part of the type interface, which is pre-created.
>

The disadvantage is that it does not permit irregularly spaced units.

-Nathan


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: GSoC - proposal - Materialized Views in PostgreSQL
Next
From: "Erik Rijkers"
Date:
Subject: testing HS/SR - 1 vs 2 performance