Re: On partitioning - Mailing list pgsql-hackers

From Amit Langote
Subject Re: On partitioning
Date
Msg-id 00cb01d018c2$9eb97260$dc2c5720$@lab.ntt.co.jp
Whole thread Raw
In response to Re: On partitioning  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: On partitioning  (Robert Haas <robertmhaas@gmail.com>)
List 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





pgsql-hackers by date:

Previous
From: Kouhei Kaigai
Date:
Subject: Re: Join push-down support for foreign tables
Next
From: Josh Berkus
Date:
Subject: Re: Commitfest problems