RE: Help with list partitioning on expression

2018-10-21 Thread Dinko Papak
pak Cc: pgsql-general@lists.postgresql.org Subject: Re: Help with list partitioning on expression On 19 October 2018 at 02:49, Dinko Papak wrote: > I have created table partitioned by list on expression using timestamp > column, so for each timestamp value function returns int and each partitio

Re: Help with list partitioning on expression

2018-10-21 Thread David Rowley
On 19 October 2018 at 02:49, Dinko Papak wrote: > I have created table partitioned by list on expression using timestamp > column, so for each timestamp value function returns int and each partition > table is for single value (range of timestamp for which function result is > the same). This help

Help with list partitioning on expression

2018-10-18 Thread Dinko Papak
I have created table partitioned by list on expression using timestamp column, so for each timestamp value function returns int and each partition table is for single value (range of timestamp for which function result is the same). This helps me to simplify querying as I do not need to always w