Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ui3Yt-007Cor-4F for pgsql-general@arkaria.postgresql.org; Sat, 02 Aug 2025 04:09:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ui3Yq-00AklP-SC for pgsql-general@arkaria.postgresql.org; Sat, 02 Aug 2025 04:09:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ui3Yp-00AklH-Oz for pgsql-general@lists.postgresql.org; Sat, 02 Aug 2025 04:09:32 +0000 Received: from fhigh-b8-smtp.messagingengine.com ([202.12.124.159]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1ui3Ym-000Icy-25 for pgsql-general@lists.postgresql.org; Sat, 02 Aug 2025 04:09:30 +0000 Received: from phl-compute-03.internal (phl-compute-03.phl.internal [10.202.2.43]) by mailfhigh.stl.internal (Postfix) with ESMTP id 3CB2E7A18C6; Sat, 2 Aug 2025 00:09:28 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-03.internal (MEProxy); Sat, 02 Aug 2025 00:09:28 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm2; t=1754107768; x=1754194168; bh=lzsO5TQ7R0FrIt5SpZToWeRDUepK0YIxRSyUFpcgck4=; b= enuUVoxjZMaJUy7bsGm+QmsmTW87/nAnEEpbxy4VhJDJKS1i5Pnw4EqoXbvabC4A 4PrEbn0l99z1DYlhgckwfVa5TV61HFYjjeEeyVvhedp86ndTGmM+Gyymu6ClF6mK 8/b7R/WszW0yw34ie14VQvapNYGVWdZU9NMnqFNUeNN9mj7H1qd+V+hans47VwS7 sfHF5ynOc75LSDy6eVlEsGmUwYEIcXAKbly2a7I+UXjzl7WJqpYXkS/IlF9d6bHb itrp+mX9a7muLQgmdsNR476Fq6FS5RaBbtv7cQaouC5vAFyoRqTwD211ZYKn3gnW s0z+cxps0R0mVmSDWug6Lw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1754107768; x= 1754194168; bh=lzsO5TQ7R0FrIt5SpZToWeRDUepK0YIxRSyUFpcgck4=; b=e 0T1D8bmXw4UBXE6TMbTUMohZNRksX4eOhFx/ZKWHhHt00gEfVdZkp+PQejLcwAno /ebrJM5hPnARp195RNOJ5GIUQenldzdncKrEBAUte7D3iumm/DIytQqGSR/xHx+i DatUbYsbAmbiAvXMTaD31tu5D0zZLVkGH/ube8KP6Iu1Q12+dMN7i18JQre7j7NR K1EDYfPSs3aijB8o48vQUJwYqUdAp+SdQLeaixZ74/tQxKIUTm2+FcDue2JB4sNm iuWvcGrqEmhi3zVefZ5LUWv9GgbtV6VYXYAS47tj5XJV1ocQKOWX617SkEN+V0KB VQAl96gATEaX6pQ9/3UIw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdefgddutdehheekucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf gurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpeetughrihgr nhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomh eqnecuggftrfgrthhtvghrnhepuedufeejjefggfdttdeghefgkeeuveekkeeiteettdek ffehiedvtefhveffgeeunecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenuc evlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgr nhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmpdhnsggprhgtphhtthhopeehpdhmoh guvgepshhmthhpohhuthdprhgtphhtthhopehikhhorhhothdtudesghhmrghilhdrtgho mhdprhgtphhtthhopegurghvihgurdgsrghrsghouhhrsegrmhhirhgrlhgvrghrnhhinh hgrdgtohhmpdhrtghpthhtohepiigvphhpihgvrhhisehgmhgrihhlrdgtohhmpdhrtghp thhtohepgihofhesthhhvggsuhhilhgurdgtohhmpdhrtghpthhtohepphhgshhqlhdqgh gvnhgvrhgrlheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 2 Aug 2025 00:09:27 -0400 (EDT) Message-ID: Date: Fri, 1 Aug 2025 21:09:26 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Get info about the index To: Igor Korot Cc: David Barbour , Jon Zeppieri , Christophe Pettus , "pgsql-generallists.postgresql.org" References: <090d8588-e74e-4436-8f69-05ce8624379b@aklaver.com> <0BC8BEBF-3B1F-4E69-A1B9-CCCDF9617168@thebuild.com> <7281c379994ffc70cebb68423f5b8ba339d0d75f.camel@cybertec.at> <2fad4427bff83bc73f9b4215e284a76343f046f2.camel@cybertec.at> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 8/1/25 20:50, Igor Korot wrote: > Adrian, > >>> >>> If I read the docs correctly, this field indicates whether the >>> WHERE condition is actually present. >>> >>> Am I right? >> >> No, it refers to: >> >> https://www.postgresql.org/docs/current/ddl-constraints.html#DDL-CONSTRAINTS-EXCLUSION > > Thx for clarification. > > But is there a field that I'm referencing above? This was answered here: https://www.postgresql.org/message-id/2fad4427bff83bc73f9b4215e284a76343f046f2.camel%40cybertec.at >> Adrian Klaver >> adrian.klaver@aklaver.com -- Adrian Klaver adrian.klaver@aklaver.com