in the query must be a constant, and
cannot be a result of a built-in function in order for
constraint_exclusion to work correctly?
Thanks,
Kevin
Kevin Keith wrote:
I have a case where I am partitioning tables based on a date range in
version 8.1.4. For example:
table_with_millions_of_
I have a case where I am partitioning tables based on a date range in
version 8.1.4. For example:
table_with_millions_of_records
interaction_id char(16) primary key
start_date timestamp (without timezone) - indexed
.. other columns
child_1 start_date >= 2006-07-21 00:00:00
child_2 start_