Hi Alban,
I was wrong: i have only one column: tsrarnge.
Which index can i create to use this statement fastly:
... AND timestamp <@ '[2016-12-27 00:00:00, 2016-12-31 00:00:00)'::tsrange
Thank you again!
/F
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
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
>>And, basically, if you need help with some queries you could try
>>posting them whole, even redacted, along the table defs, this way
>>perople can see the problem and not invent one based on a partial
>>description
Thank you very much, very kind from you.
The index applied on the timestamp fiel
conto di Job [j...@colliniconsulting.it]
Inviato: venerdì 30 dicembre 2016 10.55
A: David G. Johnston
Cc: pgsql-general@postgresql.org
Oggetto: R: [GENERAL] Special index for "like"-based query
>>GIST
>>https://www.postgresql.org/docs/9.6/static/pgtrgm.html
>>https:/
>>GIST
>>https://www.postgresql.org/docs/9.6/static/pgtrgm.html
>>https://www.postgresql.org/docs/9.6/static/btree-gist.html
I tried with a GIST-like index and queries improves a lot, thank you!
Furthermore, this type of index is also suitable for a timestamp query, where
we can mix date and t