I have a column of type
text and I want to search over this column using this SQL operator
@> operator, it filters the data as such ['a','b'] in ['a','b','c']
The returned objects will be those where the values passed are a subset of the data
The problem though is that integer comparison is better than string comparison.
I'm thinking of another way maybe if Postgres hashes the values and only then it compares.
Note, I cannot make use of indexes because there is not only one column, moreover, the query will first filter on some id and then it needs to filter those multi-valued columns.
My question, Is there is some feature in Postgresql that supports comparing integers instead of strings.