Thread

1. Does WITHOUT OVERLAPS boolean stored somewhere?

   Igor Korot <ikorot01@gmail.com> — 2026-03-28T04:54:12Z

   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.
   
   
   
   

2. Re: Does WITHOUT OVERLAPS boolean stored somewhere?

   Julien Rouhaud <rjuju123@gmail.com> — 2026-03-28T05:04:56Z

   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.
   
   
   
   

3. Re: Does WITHOUT OVERLAPS boolean stored somewhere?

   Igor Korot <ikorot01@gmail.com> — 2026-03-28T05:23:14Z

   Julien,
   
   On Sat, Mar 28, 2026 at 12:05 AM Julien Rouhaud <rjuju123@gmail.com> wrote:
   >
   > 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.
   
   Thank you.