Re: Get info about the index

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Get info about the index
Дата
Msg-id ed4a1e4f-c601-4ce1-a45e-a65547c5e286@aklaver.com
обсуждение исходный текст
Ответ на Re: Get info about the index  (Igor Korot <ikorot01@gmail.com>)
Ответы Re: Get info about the index
Список pgsql-general
On 8/1/25 17:06, Igor Korot wrote:
> Hi, Laurenz,

> 
> I'm looking at the pg_index table and I see it has:
> 
> [quote]
> indisexclusion bool
> 
> If true, this index supports an exclusion constraint
> [/quote]
> 
> 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

> 
> Thank you.
> 
>>
>> Yours,
>> Laurenz Albe


-- 
Adrian Klaver
adrian.klaver@aklaver.com



В списке pgsql-general по дате отправления: