| From: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com> |
| Cc: | Ildar Musin <i(dot)musin(at)postgrespro(dot)ru>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Declarative partitioning |
| Date: | 2016-06-21 08:13:12 |
| Message-ID: | 6ddb42c9-2870-92e2-b371-07ae81bbcc06@lab.ntt.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2016/06/21 16:49, Ashutosh Bapat wrote:
> Hi Amit,
> I tried creating partitioned table by range on an expression like
> CREATE TABLE pt1_e (a int, b int, c varchar) PARTITION BY RANGE(a +
> b);
> ERROR: syntax error at or near
> "+"
>
> LINE 1: ...E pt1_e (a int, b int, c varchar) PARTITION BY RANGE(a + b);
>
> But when I try to create partitioned table by range on expression chr(a) it
> works.
The expression needs to be parenthesized (function call expressions don't
need though). So something like the following would work:
CREATE TABLE pt1_e (a int, b int, c varchar) PARTITION BY RANGE(add(a, b));
Thanks,
Amit
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cédric Villemain | 2016-06-21 08:59:22 | Re: 10.0 |
| Previous Message | Ashutosh Bapat | 2016-06-21 07:49:56 | Re: Declarative partitioning |