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.96) (envelope-from ) id 1w6Lgt-004D5l-1x for pgsql-general@arkaria.postgresql.org; Sat, 28 Mar 2026 04:54:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w6Lgr-00DMo0-0U for pgsql-general@arkaria.postgresql.org; Sat, 28 Mar 2026 04:54:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w6Lgq-00DMns-2a for pgsql-general@lists.postgresql.org; Sat, 28 Mar 2026 04:54:29 +0000 Received: from mail-yx1-xb12e.google.com ([2607:f8b0:4864:20::b12e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w6Lgo-00000001bS8-0H8n for pgsql-general@lists.postgresql.org; Sat, 28 Mar 2026 04:54:28 +0000 Received: by mail-yx1-xb12e.google.com with SMTP id 956f58d0204a3-6500040ef85so1340818d50.1 for ; Fri, 27 Mar 2026 21:54:26 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774673664; cv=none; d=google.com; s=arc-20240605; b=fyHyJIouvKYwAZ/80yU1PX4BvBsQVyVoSNfwVwhLbA36AdplA4hyX6pxFzjnjt8OWv /uipaM6KL5623DTHoPj0ASD+3XDAeBYX922sFEaFcZ5eve4KAPRA2jA2xkpW9KqdcqQ4 3HNnUuNavFB5/NprDp5+RXLJdpcE5rhy9wJjG0VSgiGx7Zd9bp50DbgT6Q0JfgnMJQPB JlLnS2lXxY9Pup3R3ijq0ayQbwIjwL3LY13ak+duM7GM88JtEXSACcaCySx7oM5Zay2T JUsU5idjheVXu9BgbwWwQEsadzD4YHT1UFTK5A5Fb1mW0mZqoVRz/Zbp9LaK2OMJohDw NGHA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=+ljiAYRTn+LmmbPkhB4gmDiKBXov7tXIDGgN75fRp98=; fh=2DoGC78b0mi8uZ4UY+9ocPF86GSVzeaJWqou/x907js=; b=jJz6JVLUOztCfGixbbkJ0CZvvjrQn7mJX+fZJCD9x1/XC3FdzFJBovPZs9CaIuTgUc JzjVY8gu3W9CC4q5rymhYPE8o0yR9aeFwiGJxNXN05g/NCdioyCWdRN/N5QJqmztvZUZ 8gV+pe9eHHACirUgkg6K7LtktkrUIHtp7I00XNur8uGbM/TPl5G4rjCp5De6/PevwTif NXmNJ9AiBKDQThLkEAVFYCMgbz09/7CCUfKSmQ2Q3RXioheoexdjnh5LXsWkxKdYfdNm 4tlkf6diRlTIrd+Nwo7bHsPY5ggqNqR9k6zPG6enMcmJstjMyiQLr/IWw+R4RIhggrh6 aGQw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1774673664; x=1775278464; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=+ljiAYRTn+LmmbPkhB4gmDiKBXov7tXIDGgN75fRp98=; b=Vel768wXr2/gMOKKVlNHeX5LtYe+tTm32yBqopYOyh2f7Qsap1tHiXCO/CWRKx5izs ygd57attVQm+pry7QJsrD0hlyeuRGR8yGrLHuT8Rt/Hv7SeHNnM9NFD4Pf/gHwS7tkAU k1QGvnrjldZiTRr7nOW1dOxfJJTsoXlc0EpKKVoYZ7anAz8VsZRhDTPyhLX5yAWdhzG5 wW9NXSJjUxSmSreWXtOMT/WJklGgX5dQxS2NFJSmNK2RvZSgmE6jE3zpvQP0wI2pY1Ha C6wQ1ibPQ2w7e3oLo4EqPfL8B7LE8so0QdwsMvxWjdU/bVp4bwgpvycFccR9yDQfxAZd FryQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774673664; x=1775278464; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=+ljiAYRTn+LmmbPkhB4gmDiKBXov7tXIDGgN75fRp98=; b=mCz42/aiSfInzbtWo+GprvM5tY9IDI//EQrWR1LaK4riwsIocP+ZzVRCMR8HzuRV5m mMpDOD07nFTA7fNLaWllHXTAxToDxnEK6+mCFhuUZ7PJ9T2b3zDt/idPQLyaX81l0PQB jWCSlmoDQC6xiFj6MxFZHLMWh1ASPdVQLgbHVIuXv/dFfmjaml9APhqpTcbSXUBo87yU J6o5CT8yhEyKDqUx0iN4Dva1mIfFTz6kRd9qc2C0O5Yj7Vgo9c83WHwvn00qMkLbd5E7 OUGnoDb4M+sQTsZHz7OCR3IIYxVIuoQgfGF9WYbXunDQhFnRqkvaWdFGtRsfStRGhgsO UYkg== X-Gm-Message-State: AOJu0YzkpwmpRntjKJkbwtapyS2b8NnuUuHs0zf4l641IQbqXbzzyhTX p57kW7q0Mt7bc2OKk69qotPFE7lc07h7hVlD3X/NyLhACHJk+ZujAa4lWbNXwTPLlc7wT/sExR1 Jh5ZAOJQeD2Pm2CHTIdUZzeDuTzArYpAH7jUt X-Gm-Gg: ATEYQzwo+xea0gvmkf4d13rCqdo03xMmKcHCSym/mXrALYmBCoL4DJncqXI6GkxLyq7 q+aF5zih8nKazoBsZSBDARmWYWlAEf+JJSxOAgg9ESAYVPrYrvxwBK+Ya7CJONdRy/tRMi6BvA5 j0ANWHtepKzLbGqHcdAdzyMmLJJ+r53hGgWOvJ53MvnfqWiP66SC4Id/wlBy+H7aEsAnfr6xj4w eeQJBu0yHLrcvE6qRo3Q+oO7uMvxVil2tzxuqrAqVweOd2B9ZsvIud0jIe3gdN00suIiaDtp+ac ua631KOzdyU/obmbF8AbYWX9KzofmH1GmpZK8izrdVhsdlxtDBJaSoG1fM/s3D3Y X-Received: by 2002:a05:690c:6d81:b0:79b:d341:56f5 with SMTP id 00721157ae682-79bddd015demr55091547b3.14.1774673664460; Fri, 27 Mar 2026 21:54:24 -0700 (PDT) MIME-Version: 1.0 From: Igor Korot Date: Fri, 27 Mar 2026 23:54:12 -0500 X-Gm-Features: AQROBzD_o2_m1uqcLEs_DTkUwQGxN--dOrvlL3Z_5y9K0Z4N5yhTlVXHVhIqGdc Message-ID: Subject: Does WITHOUT OVERLAPS boolean stored somewhere? To: "pgsql-generallists.postgresql.org" Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, I can use WITHOUT OVERLAPS when creating the PK. But is it stored somewhere? I mean can I write a query like "SELECT without_overlaps FROM ..." and get the value of T/F or 1/0 which will indicate if the clause was used? Thank you.