Re: GIN index partial match

2022-06-14 Thread Pavel Borisov
On Tue, Jun 14, 2022 at 11:39 AM huangning...@yahoo.com < huangning...@yahoo.com> wrote: > 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:

GIN index partial match

2022-06-14 Thread huangning...@yahoo.com
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