declarative partition by list, "other values" syntax

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: declarative partition by list, "other values" syntax
Date: 2017-11-20 20:52:48
Message-ID: 1511211168922-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I was trying to create a partitionned table by list,
that has on special partition for "other values"

for exemple
create table wiki_data_part(
category varchar(20),
tim_id bigint,
pag_id bigint,
requests int,
size bigint
)
PARTITION BY LIST (category );

CREATE TABLE wiki_data_part_a PARTITION OF wiki_data_part
FOR VALUES IN ('ang.q','ace.mw', ...);

CREATE TABLE wiki_data_part_b PARTITION OF wiki_data_part
FOR VALUES IN ('bs.s','bh.mw','bar','br.d', ...);

How could I create a partition containing the other values (like MINVALUE,
MAXVALUE for range partition) ?

CREATE TABLE wiki_data_part_others PARTITION OF wiki_data_part
FOR VALUES IN (others);

could not find it in doc
https://www.postgresql.org/docs/10/static/sql-createtable.html

Thanks in advance
Regards
PAscal

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2017-11-20 20:54:25 Re: To all who wish to unsubscribe
Previous Message Alvaro Herrera 2017-11-20 20:52:40 Re: To all who wish to unsubscribe