GIN Index Partial Match?

From: 黄宁 <huangning0722(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: GIN Index Partial Match?
Date: 2022-10-26 02:47:43
Message-ID: CAKgrFs9WNCxx6U0A2kybbxKtad08y1kVvj+thra7zo3h8TS0PA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

I create a gin index for a custom type. I want to use partial match, but I
find extract query method called twice in a query, when in the first
called, I return the minimal value of the type, and I want to set the
maximal value of the type in extra data will be used in compare partial
function ,But in the second extrace query function called,the query value
is the first my return.It's weird. ,how i can set the extra data correctly?

Thank You!

Browse pgsql-general by date

  From Date Subject
Next Message Yi Sun 2022-10-26 05:37:10 Re: How to know how much CPU, RAM is used by existing 1 database
Previous Message Rama Krishnan 2022-10-26 01:13:05 Value Too long varchar(100)