Re: GIN index partial match

Hi:

I create a gin index for a bigint array. and then  want to find the array which contains the key is start with special prefix. for example:

row1: { 112, 345, 118}

row2: { 356, 258, 358}

row3: { 116, 358, 369}

I want find the key start "11",so the row1 and row3 will be return.of course it must be use GIN index not seq scan。