Postgres Pro
Downloads
Home   >   mailing lists

GIN index partial match - Mailing list pgsql-hackers

From huangning290@yahoo.com
Subject GIN index partial match
Date
Msg-id 781192371.2636607.1655177752532@mail.yahoo.com
Whole thread Raw
Responses Re: GIN index partial match  (Pavel Borisov <pashkin.elfe@gmail.com>)
List pgsql-hackers
Tree view
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!

pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Typo in ro.po file?
Next
From: "wangw.fnst@fujitsu.com"
Date:
Subject: RE: Perform streaming logical transactions by background workers and parallel apply