Horton

Re: On partitioning

Amit Langote <langote_amit_f8@lab.ntt.co.jp>

View thread View on postgr.es
From: "Amit Langote" <Langote_Amit_f8@lab.ntt.co.jp>
To: "'Robert Haas'" <robertmhaas@gmail.com>
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-15T23:55:35Z
Lists: pgsql-hackers 
Robert wrote:
> 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.

Oops, wrong example, sorry. In case of an otherwise good expression?

Thanks,
Amit