From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <bruce@momjian.us>
Cc: PostgreSQL-documentation <pgsql-docs@postgresql.org>
Cc: Simon Riggs <simon@2ndquadrant.com>
Subject: Re: Partitioning documentation example
Date: Sat, 05 Jan 2008 13:08:54 -0500
Message-ID: <7192.1199556534@sss.pgh.pa.us> (raw)
In-Reply-To: <200801051737.m05HbWC08088@momjian.us>
References: <200801051737.m05HbWC08088@momjian.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: tgl@sss.pgh.pa.us, bruce@momjian.us, simon@2ndquadrant.com
Subject: Re: Partitioning documentation example
In-Reply-To: <7192.1199556534@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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