GIN index partial match

From: "huangning290(at)yahoo(dot)com" <huangning290(at)yahoo(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: GIN index partial match
Date: 2022-06-14 03:35:52
Message-ID: 781192371.2636607.1655177752532@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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。

is there any example ?

Thank You!

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message wangw.fnst@fujitsu.com 2022-06-14 03:37:04 RE: Perform streaming logical transactions by background workers and parallel apply
Previous Message Peter Smith 2022-06-14 03:34:34 Typo in ro.po file?