Hello, I use tables with several "int[]" columns. I use the "@>" operator to filter my data.
To increase speed , i install the "intarray" extension. Now queries are very fast with the specific indexes (i use "gin__int_ops"). But, in few columns, i have null values in my intarray and i cannot use the "@>" operator. Because i have the error "ERROR: array must not contain nulls". The documentation says that the standard operator "@>" is overrided by the intarray extension when arguments are int[]. Do you have a solution, to rename the "@>(int{], int[])" to use it only when it is possible and to prevent the override of the current behavior ? Or if you know, how use the default @> operator instead of the override. Thank you, Eric.