Giorgio Valoti wrote:
> Hi, I have a timestamptz field that I want to use with a query, but I
> don’t need the full timestamp resolution, so I’ve created a
> day_trunc(timestamptz) immutable function which I’ll use with the query
> and with a new index:
>
> logs=> create index test_idx on blackbox (day_trunc(ts));
>
> However, the query plan doesn’t use the index:
Does it use it ever? e.g. with
SELECT * FROM blackbox WHERE day_trunk(ts) = '...'
--
Richard Huxton
Archonet Ltd