[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    GIN Index Partial Match?
From:       黄宁 <huangning0722 () gmail ! com>
Date:       2022-10-26 2:47:43
Message-ID: CAKgrFs9WNCxx6U0A2kybbxKtad08y1kVvj+thra7zo3h8TS0PA () mail ! gmail ! com
[Download RAW message or body]

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!

[Attachment #3 (text/html)]

<div dir="ltr">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&#39;s weird. ,how i \
can set the extra data correctly?<div><br></div><div>Thank You!</div></div>



[prev in list] [next in list] [prev in thread] [next in thread]