Re: Doubt with [ RANGE partition with TEXT datatype ]

On Mon, Apr 19, 2021 at 2:16 PM Amit Langote wrote: > Hi Prabhat, > > On Mon, Apr 19, 2021 at 5:13 PM Prabhat Sahu > wrote: > > > > Hi All, > > > > Please help me out with my doubt in RANGE partition with TEXT datatype: > > > > postgres=# create

Re: Doubt with [ RANGE partition with TEXT datatype ]

Hi Prabhat, On Mon, Apr 19, 2021 at 5:13 PM Prabhat Sahu wrote: > > Hi All, > > Please help me out with my doubt in RANGE partition with TEXT datatype: > > postgres=# create table tab1 (col1 text) PARTITION BY RANGE (col1); > CREATE TABLE > > postgres=# create tab

Doubt with [ RANGE partition with TEXT datatype ]

Hi All, Please help me out with my doubt in RANGE partition with TEXT datatype: postgres=# create table tab1 (col1 text) PARTITION BY RANGE (col1); CREATE TABLE postgres=# create table p1 (col1 text); CREATE TABLE -- Partition with range from '5' to '10' shows error: postgres=# alter table