KOPOSOV Sergey <Sergey.Koposov@xxxxxxxx> 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 that at the moment. In principle the range case could be converted to something like "integer_column >= lower_value AND integer_column <= upper_value" by attaching a support function to <@ and implementing the SupportRequestIndexCondition API. I think it could only work for a plan-time-constant range though, else you'd not know whether to use equality or inequality bounds. (Hmm ... or maybe, use equality always and treat it as a lossy conversion? But infinite bounds would still be a headache.) regards, tom lane
