MIME-Version: 1.0
References: <CA+FnnTw2ouEQKSKzQ_SNo8efWE8wEqjr9Ux-F-wbR+y=Pn6bGg@mail.gmail.com>
 <090d8588-e74e-4436-8f69-05ce8624379b@aklaver.com> <CA+FnnTyKb0cLp9GF3YENoBZ4LVW3db_RSGR99BPFnA4BZtc8kQ@mail.gmail.com>
 <0BC8BEBF-3B1F-4E69-A1B9-CCCDF9617168@thebuild.com> <CA+FnnTy8bdXxFZBmFfm1oNMQLVxL-+UmkX8EecbLB0MehX8gFw@mail.gmail.com>
 <CAKfDxxw=4Vax5Oq0apoAE=RkzNgHwvHzKX1ejE6z7n7_vtGBUQ@mail.gmail.com>
 <CAEMHB2QQpfxjbqbyB6zy+TMv9zf42tavLuYUSxDXgyZEaq46Xg@mail.gmail.com>
 <7281c379994ffc70cebb68423f5b8ba339d0d75f.camel@cybertec.at>
 <CA+FnnTyFwR_Xk8pEhasG7GGWAzFk9e4tCBdX36G6H1-=uJxrfg@mail.gmail.com>
 <2fad4427bff83bc73f9b4215e284a76343f046f2.camel@cybertec.at> <CA+FnnTzA5+78w3UbkQCTd74GPqpB=D=tu0eEccqX9301TTcynQ@mail.gmail.com>
In-Reply-To: <CA+FnnTzA5+78w3UbkQCTd74GPqpB=D=tu0eEccqX9301TTcynQ@mail.gmail.com>
From: Jon Zeppieri <zeppieri@gmail.com>
Date: Fri, 1 Aug 2025 20:27:38 -0400
Message-ID: <CAKfDxxy7ozvUj1mWCZRM=-L5z00S8wXUW+d1KKw56nG+yXo0MA@mail.gmail.com>
Subject: Re: Get info about the index
To: Igor Korot <ikorot01@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, 
	David Barbour <david.barbour@amiralearning.com>, Christophe Pettus <xof@thebuild.com>, 
	Adrian Klaver <adrian.klaver@aklaver.com>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAKfDxxy7ozvUj1mWCZRM%3D-L5z00S8wXUW%2Bd1KKw56nG%2ByXo0MA%40mail.gmail.com>
Precedence: bulk

On Fri, Aug 1, 2025 at 8:06=E2=80=AFPM Igor Korot <ikorot01@gmail.com> wrot=
e:
>
> If I read the docs correctly, this field indicates whether the
> WHERE condition is actually present.
>

Are you referring to the condition on a partial index? You can get
that using pg_get_expr():

select pg_get_expr(indpred, indrelid) from pg_index where indexrelid =3D
'my_partial_index'::regclass;

- Jon