Soni writes:
>> currently we are planning to migrate inheritance partitioning to
>> declarative partitioning by range values of int on pg10. But the key
>> values can contain null. I know that range partitioning does not allow
>> null values.
In v11 you could use a default partition ...
I think it's better to had list partitioning of true/false based on
(int_key_column is null)
CREATE TABLE partitioned_table_name (like table_name) partition by list
((int_key_column is null));
On 16/04/2019 9:37, Soni wrote:
Hello All,
currently we are planning to migrate inheritance partition
Hello All,
currently we are planning to migrate inheritance partitioning to
declarative partitioning by range values of int on pg10. But the key
values can contain null. I know that range partitioning does not allow
null values.
We are looking for workaround for this, that is create a list
par
