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.