Boolean partitions syntax

Поиск
Список
Период
Сортировка
От Amit Langote
Тема Boolean partitions syntax
Дата
Msg-id e05c5162-1103-7e37-d1ab-6de3e0afaf70@lab.ntt.co.jp
обсуждение исходный текст
Ответы Re: Boolean partitions syntax  (Dilip Kumar <dilipbalaut@gmail.com>)
Re: Boolean partitions syntax  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
Список pgsql-hackers
Hi.

Horiguchi-san pointed out [1] on a nearby thread that the partitioning
syntax (the FOR VALUES clause) doesn't accept true and false as valid
partition bound datums, which seems to me like an oversight.  Attached a
patch to fix that.

create table bools (a bool) partition by list (a);

Before patch:

create table bools_t partition of bools for values in (true);
ERROR:  syntax error at or near "true"
LINE 1: ...reate table bools_t partition of bools for values in (true);

After:

create table bools_t partition of bools for values in (true);
CREATE TABLE
\d bools_t
              Table "public.bools_t"
 Column |  Type   | Collation | Nullable | Default
--------+---------+-----------+----------+---------
 a      | boolean |           |          |
Partition of: bools FOR VALUES IN (true)

Thanks,
Amit

[1]
https://www.postgresql.org/message-id/20171128.203915.26713586.horiguchi.kyotaro%40lab.ntt.co.jp

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: User defined data types in Logical Replication
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Testing Extension Upgrade Paths