Re: Extension intarray and null values

2021-02-25 Thread Eric Brison
ull values. But i'm not sure that this function name is safe in all postgresql version (>= 10) Eric. Le jeu. 25 févr. 2021 à 16:06, Tom Lane a écrit : > Eric Brison writes: > > I use tables with several "int[]" columns. > > I use the "@>" operator

Extension intarray and null values

2021-02-25 Thread Eric Brison
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