| From: | Igor Korot <ikorot01(at)gmail(dot)com> |
|---|---|
| To: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Does WITHOUT OVERLAPS boolean stored somewhere? |
| Date: | 2026-03-28 05:23:14 |
| Message-ID: | CA+FnnTzae_L2kZL6ZqWMWtZ+mWwbKFMJMyFaEAuBS+AVBOCnWw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Julien,
On Sat, Mar 28, 2026 at 12:05 AM Julien Rouhaud <rjuju123(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hua W Peng | 2026-03-28 07:07:09 | slow sql query for big items |
| Previous Message | Julien Rouhaud | 2026-03-28 05:04:56 | Re: Does WITHOUT OVERLAPS boolean stored somewhere? |