Re: Partitioning documentation example - Mailing list pgsql-docs

From Tom Lane
Subject Re: Partitioning documentation example
Date
Msg-id 7192.1199556534@sss.pgh.pa.us
Whole thread Raw
In response to Re: Partitioning documentation example  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Partitioning documentation example
List pgsql-docs
Bruce Momjian <bruce@momjian.us> writes:
> Because my EXECUTE example didn't work I have created a new example
> using date_trunc(), which I think is less error-prone than the
> comparisons done in the original example:

This is not an improvement either.  You can't represent the check
constraints that way (at least not if you want the planner to do
constraint exclusion with them) and I don't think it's "less
error-prone" to have a different representation in the trigger than
you have in the constraints.

            regards, tom lane

pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Partitioning documentation example
Next
From: Bruce Momjian
Date:
Subject: Re: Partitioning documentation example