is it bug? - printing boolean domains in sql/xml function

Поиск
Список
Период
Сортировка
Искать
От
Pavel Stehule
Тема
is it bug? - printing boolean domains in sql/xml function
Дата
Msg-id
CAFj8pRAzNcRe_O0TVcr8KtaBbUA1sUzRbuuKQFNdy26bq8KVnA@mail.gmail.com
Список
Дерево обсуждения
is it bug? - printing boolean domains in sql/xml function Pavel Stehule <pavel.stehule@gmail.com>
Re: is it bug? - printing boolean domains in sql/xml function Noah Misch <noah@leadboat.com>
Re: is it bug? - printing boolean domains in sql/xml function Pavel Stehule <pavel.stehule@gmail.com>
Re: is it bug? - printing boolean domains in sql/xml function Pavel Stehule <pavel.stehule@gmail.com>
Re: is it bug? - printing boolean domains in sql/xml function Tom Lane <tgl@sss.pgh.pa.us>
Re: is it bug? - printing boolean domains in sql/xml function Pavel Stehule <pavel.stehule@gmail.com>
Re: is it bug? - printing boolean domains in sql/xml function Peter Eisentraut <peter_e@gmx.net>
Re: is it bug? - printing boolean domains in sql/xml function Szymon Guz <mabewlun@gmail.com>
Re: is it bug? - printing boolean domains in sql/xml function Pavel Stehule <pavel.stehule@gmail.com>
Re: is it bug? - printing boolean domains in sql/xml function Pavel Stehule <pavel.stehule@gmail.com>
Re: is it bug? - printing boolean domains in sql/xml function Pavel Stehule <pavel.stehule@gmail.com>
Hello

related to http://www.postgresql.org/message-id/CAFj8pRDTAVfNrAzwEt+ewMfRBDZFfVa8W17Kk_E12fb6T-ZNXQ@mail.gmail.com

boolean domains is serialised to string different than boolean

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
---------------------------------------------truet
(1 row)

is it expected behave?

Regards

Pavel


В списке pgsql-hackers по дате отправления
От: Pavel Stehule
Дата:
Сообщение: Re: enhanced error fields
От: Boszormenyi Zoltan
Дата:
FAQ