Re: [HACKERS] Order-preserving function transforms and EquivalenceClass

2017-03-24 Thread Tom Lane
Mat Arye writes: > We are trying to extend/hook into the planner so that it understands that > date_trunc('minute', time) has the same ordering as time (or rather that a > sort ordering on the latter is always a valid sort ordering on the former). > But this question really

[HACKERS] Order-preserving function transforms and EquivalenceClass

2017-03-23 Thread Mat Arye
Hi, I am on a team developing an open-source extension for time-series data storage in PostgreSQL (https://github.com/timescaledb/timescaledb). We are trying to extend/hook into the planner so that it understands that date_trunc('minute', time) has the same ordering as time (or rather that a