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 88EF58F000EC4B4684700C2AA3A73D7A08054EACC1A8@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 
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
timezone ...  

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

pgsql-general by date:

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