Postgres Pro
Downloads
Home   >   mailing lists

R: [GENERAL] Special index for "like"-based query - Mailing list pgsql-general

From Job
Subject R: [GENERAL] Special index for "like"-based query
Date
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A08054EACC1AC@W2008DC01.ColliniConsulting.lan
Whole thread Raw
In response to Re: [GENERAL] Special index for "like"-based query  (Alban Hertroys <haramrae@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Job
Date:
Subject: R: [GENERAL] Special index for "like"-based query
Next
From: Francisco Olarte
Date:
Subject: Re: [GENERAL] Special index for "like"-based query