R: Special index for "like"-based query

From: Job <Job(at)colliniconsulting(dot)it>
To: 'Alban Hertroys' <haramrae(at)gmail(dot)com>, Job <Job(at)colliniconsulting(dot)it>
Cc: Francisco Olarte <folarte(at)peoplecall(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: R: Special index for "like"-based query
Date: 2016-12-30 12:49:58
Message-ID: 88EF58F000EC4B4684700C2AA3A73D7A08054EACC1AC@W2008DC01.ColliniConsulting.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2016-12-30 13:03:14 Re: Special index for "like"-based query
Previous Message Job 2016-12-30 12:13:50 R: Special index for "like"-based query