On 10 January 2018 at 04:24, Jeff Davis <pgsql@j-davis.com> wrote:
> On Sat, Jan 6, 2018 at 10:38 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
>> For this to be useful, it needs to include some details of how to use
>> it when people have NOT used range datatypes in their tables.
>
> Good idea. I added an example that doesn't have range types in the base table.
Cool, thanks
...
It would be useful to consider any related use cases.
Are there applications for range operators other than &&?
Do we optimize for TIMESTAMP <@ RANGE as well?
Does this link in nicely with partition-aware joins?
Does it allow partition exclusion if you join a daterange to a time
range partitioned table?
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services