Re: Empty Range Bound Specified for Partition

Thank you for the clarification.

On Thu, 22 Nov 2018 at 13:30, Alban Hertroys <haramrae(at)gmail(dot)com> wrote:

>
> > On 22 Nov 2018, at 7:21, ramsiddu007 <ramsiddu007(at)gmail(dot)com> wrote:
> >
> > pgsql> create table test_upto_100 partition of test_parent_partition
> > for values from ('51') to ('100');
> >
> > It was showing error like this..
> >
> > ERROR: empty range bound specified for partition "test_upto_100"
> > DETAIL: Specified lower bound ('51') is greater than or equal to upper
> bound ('100').
> > SQL state: 42P17
> >
> >
> > I am not getting, please give me cause of this and
> solution.
>
> Alphabetically, '1' comes before '5', so '100' comes before '51'.
> Numerically, you would get what you intended, but you're not partitioning
> on numbers but on strings instead and those sort alphabetically: '1', '10',
> '100', '11', '2', '3', '51', etc.
>
> Alban Hertroys
> --
> If you can't see the forest for the trees,
> cut the trees and you'll find there is no forest.
>
>

--
*Best Regards:*
Ramanna Gunde

*Don't complain about the HEAT,*

*PLANT A .*