Dear Alban, Regarding: >>... AND timestamp BETWEEN '2016-12-27 00:00:00'::timestamp with time zone AND '2016-12-30 23:59:59'::timestamp with time zone ... I think it is a very good approach, and i would like to try. My table has got two different field for "starting" and "ending" timestamp values. Shall i create an index together with the two field (starting and ending) with the "tsrange" statement? Thank you again! /F -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
