Horton

Re: On partitioning

Robert Haas <robertmhaas@gmail.com>

View thread View on postgr.es
From: Robert Haas <robertmhaas@gmail.com>
To: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>, Claudio Freire <klaussfreire@gmail.com>, Josh Berkus <josh@agliodbs.com>, Tom Lane <tgl@sss.pgh.pa.us>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2014-12-15T18:55:01Z
Lists: pgsql-hackers 
On Sun, Dec 14, 2014 at 9:12 PM, Amit Langote
<Langote_Amit_f8@lab.ntt.co.jp> wrote:
> This means if a user puts arbitrary expressions in a partition definition, say,
>
> ... FOR VALUES  extract(month from current_date) TO extract(month from current_date + interval '3 months'),
>
> we make sure that those expressions are pre-computed to literal values.

I would expect that to fail, just as it would fail if you tried to
build an index using a volatile expression.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company