David Gauthier <dfgpostgres@gmail.com> writes: > I'm asking about the possibility of indexing portions of a column's value > where the column has a static field format.
GIN indexes are meant for exactly that. You might have to write your own opclass to break up the input values in the way you want though.
A less difficult answer would be to write a function that breaks up the input into (say) an array of text and then use the existing GIN array support. But you'd pay for that by needing to write more complicated queries to use the index.
regards, tom lane
Hello David,
Reading your mail, it seems that your data column contains 3 different kinds of atomic information:
* Characters 1-2
* Characters 3-4
* Characters 5-8
Does it make sense to split this data into 3 separate columns?