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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1w6LrA-004DGC-1S
	for pgsql-general@arkaria.postgresql.org;
	Sat, 28 Mar 2026 05:05:08 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1w6Lr8-00DPsk-2Q
	for pgsql-general@arkaria.postgresql.org;
	Sat, 28 Mar 2026 05:05:07 +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 <rjuju123@gmail.com>)
	id 1w6Lr8-00DPsb-1O
	for pgsql-general@lists.postgresql.org;
	Sat, 28 Mar 2026 05:05:06 +0000
Received: from mail-pl1-x62e.google.com ([2607:f8b0:4864:20::62e])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.98.2)
	(envelope-from <rjuju123@gmail.com>)
	id 1w6Lr6-00000001bW8-0MU7
	for pgsql-general@lists.postgresql.org;
	Sat, 28 Mar 2026 05:05:06 +0000
Received: by mail-pl1-x62e.google.com with SMTP id d9443c01a7336-2b0c8362d93so14417175ad.3
        for <pgsql-general@lists.postgresql.org>; Fri, 27 Mar 2026 22:05:04 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20251104; t=1774674302; x=1775279102; darn=lists.postgresql.org;
        h=in-reply-to:content-disposition:mime-version:references:message-id
         :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to;
        bh=nxHxxWYy+EGoG5P2L1cujdJ6M/6YTtjq3CGacSxe51o=;
        b=h/yfbuHyj0Ns51mAY+Js5OG4FNwYrO6afmgo5qLlH0PrJDJ0T6VM6oKG1C4YD1nW8A
         FPfcC4IL84rPY8urvIWakhAqMfBS75opbvh7OW4KT3eMbxS/oGFWRsB7HcFt1D7yPEzc
         S7p+0+5hvzpgN+xL2LoqWyiuYh3TRcasbk4decvApJxtcYcKiwaJtoWQZtoYweHC0mz7
         vSgVilBxUp73D8d4Itv4zdq1EPQg7SPPU4BLhEgvfhBjcr5NBLZP16IdwCjy7P0M1fKM
         gWteifYnajHoGpLy7JVvii8KFciAQlN/lWV3U2ug00QAR8Dgspdv9XcCBKloL3lLYBX9
         tKnA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20251104; t=1774674302; x=1775279102;
        h=in-reply-to:content-disposition:mime-version:references:message-id
         :subject:cc:to:from:date:x-gm-gg:x-gm-message-state:from:to:cc
         :subject:date:message-id:reply-to;
        bh=nxHxxWYy+EGoG5P2L1cujdJ6M/6YTtjq3CGacSxe51o=;
        b=Ne2sZz4dcMx/VlFayz+ELDqVXPZi3Yy1jc9vzQta7XF1+rXQVv+dtVhP7rQMnYWOQ7
         nh9n9NzhIdFH84RJxtKb7l6PVFOby2B35Yh2XSFLeH6ZeYVEOa+i6cipFa8quFIuL+12
         wc20abVVnBgHUZ1DGT6DYOWgLWgqQE95zzmgOaSm+fG2b3vzpXdXq8WPujmEkulhdwMN
         KX9SXa4zS+7mq6eKt2mOzgH/nhSIeUsAKKtONJcElJrg4setA0Qjtpha8plOEHD027A0
         rfDxJVMZBlesvlvVK+ucSf0i030N2dsDSTo37x9qQ2lUmqsnhpAE4yrURx7MiGXWBDI9
         Pr3A==
X-Gm-Message-State: AOJu0YxW8gL7cKu521cWA+PI9dL3FG3/lgSCpgO+/Sq6rgeViSqvbqmj
	ysyWg1k2SkF+C1EoZF+TvmU0WJ89BQeD510ZB5nJSTzTIFudHL2S4PKIjkG7pw==
X-Gm-Gg: ATEYQzxr7xI4HR94cCHQ/Z78o1orIGwUJracIxmXjeYbM1SR8ouSc9s8DiJ3l352wRM
	TtoUgfnZ1PBHyJCkwK2MC29iZaHkPaB4ZvZH5cmiGUPkY1ufKESlGtU7eIy9HKSLfrnikiBlhuY
	ycO6QtTXVNK5XKHX3lBCcNaRHqihc6/ZRxGC4M3GF1pLCtoCtZQ3T3JohTR7Y3jC8Jxs6uub6yu
	9GglV7eHsvueBj4SP2jxACxnlMvaErINJHY3ZJDn158ji4lhUomn+uRq2ymJSmQCVzPnxVhAEfz
	IKSb+ZD+f33Wgh9YfOsG3Qy9er3pctxKIPdQMcoiJ/QOEAKfSWsvpg2BTg76iv6gp9TgBNeqClo
	v5+Sm/mBs9hRbV0OC3XWJhHJdc828p2R1EEoTXXfJSLs1OC2ATTQYhXg6MjykoaQAH0vlV2RHAh
	MzYlSR+gMsNQ2k6Xk=
X-Received: by 2002:a17:902:c943:b0:2ae:6192:8d78 with SMTP id d9443c01a7336-2b0cdc033f9mr55223765ad.1.1774674302117;
        Fri, 27 Mar 2026 22:05:02 -0700 (PDT)
Received: from jrouhaud ([115.43.41.38])
        by smtp.gmail.com with ESMTPSA id d9443c01a7336-2b2427b1ef0sm11840465ad.74.2026.03.27.22.05.00
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Fri, 27 Mar 2026 22:05:01 -0700 (PDT)
Date: Sat, 28 Mar 2026 13:04:56 +0800
From: Julien Rouhaud <rjuju123@gmail.com>
To: Igor Korot <ikorot01@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: Does WITHOUT OVERLAPS boolean stored somewhere?
Message-ID: <acdheJh41B7sM2PG@jrouhaud>
References: <CA+FnnTywbXTAYp1vbPERX_q1+k1qF02RNj+tR_LNbEtMVRLB=g@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <CA+FnnTywbXTAYp1vbPERX_q1+k1qF02RNj+tR_LNbEtMVRLB=g@mail.gmail.com>
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/acdheJh41B7sM2PG%40jrouhaud>
Precedence: bulk

Hi,

On Fri, Mar 27, 2026 at 11:54:12PM -0500, Igor Korot wrote:
> 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?

It's the conperiod attribute of pg_constraint, see
https://www.postgresql.org/docs/current/catalog-pg-constraint.html for all use
cases.