pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedDoes WITHOUT OVERLAPS boolean stored somewhere?
3+ messages / 2 participants
[nested] [flat]
* Does WITHOUT OVERLAPS boolean stored somewhere?
@ 2026-03-28 04:54 Igor Korot <ikorot01@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Igor Korot @ 2026-03-28 04:54 UTC (permalink / raw)
To: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Does WITHOUT OVERLAPS boolean stored somewhere?
@ 2026-03-28 05:04 Julien Rouhaud <rjuju123@gmail.com>
parent: Igor Korot <ikorot01@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Julien Rouhaud @ 2026-03-28 05:04 UTC (permalink / raw)
To: Igor Korot <ikorot01@gmail.com>; +Cc: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Does WITHOUT OVERLAPS boolean stored somewhere?
@ 2026-03-28 05:23 Igor Korot <ikorot01@gmail.com>
parent: Julien Rouhaud <rjuju123@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Igor Korot @ 2026-03-28 05:23 UTC (permalink / raw)
To: Julien Rouhaud <rjuju123@gmail.com>; +Cc: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2026-03-28 05:23 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-03-28 04:54 Does WITHOUT OVERLAPS boolean stored somewhere? Igor Korot <ikorot01@gmail.com>
2026-03-28 05:04 ` Julien Rouhaud <rjuju123@gmail.com>
2026-03-28 05:23 ` Igor Korot <ikorot01@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox