inconsistent behave of boolean based domains in XML functions

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема inconsistent behave of boolean based domains in XML functions
Дата
Msg-id CAFj8pRDTAVfNrAzwEt+ewMfRBDZFfVa8W17Kk_E12fb6T-ZNXQ@mail.gmail.com
обсуждение исходный текст
Список pgsql-hackers
Hello

On Czech pg mailing list was reported issue about problems with
boolean based domains and XML functions.

There are maybe more issues, but probably there is little bit strange
and unexpected result

postgres=# CREATE DOMAIN booldomain as bool;
CREATE DOMAIN

-- fully expected behave
postgres=# select true, true::booldomain;bool | booldomain
------+------------t    | t
(1 row)

postgres=# select true::text, true::booldomain::text;text | text
------+------true | true
(1 row)

-- unexpected behave
postgres=# select xmlforest(true as bool, true::booldomain as booldomain);                 xmlforest
---------------------------------------------<bool>true</bool><booldomain>t</booldomain>
(1 row)

Best regards

Pavel Stehule



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

Предыдущее
От: Benedikt Grundmann
Дата:
Сообщение: Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Extra XLOG in Checkpoint for StandbySnapshot