Re: int8range and index usage for <@ operator

2022-04-28 Thread KOPOSOV Sergey
On Thu, 2022-04-28 at 12:57 -0400, Tom Lane wrote: > This email was sent to you by someone outside the University. > You should only click on links or attachments if you are certain that the > email is genuine and the content is safe. > > KOPOSOV Sergey writes: > > I'm trying to understand to is t

Re: int8range and index usage for <@ operator

2022-04-28 Thread Tom Lane
KOPOSOV Sergey writes: > I'm trying to understand to is there a possibility to use an index for PG > when I have a integer column in a table and I want to execute queries with > this > integer_column <@ int8range > or > integer_column <@ int8multirange > in a where clause There's no support for

int8range and index usage for <@ operator

2022-04-28 Thread KOPOSOV Sergey
Hi, I'm trying to understand to is there a possibility to use an index for PG when I have a integer column in a table and I want to execute queries with this integer_column <@ int8range or integer_column <@ int8multirange in a where clause Here is an example *** wsdb=> create temp table