From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | inconsistent behave of boolean based domains in XML functions |
Date: | 2013-01-09 08:45:10 |
Message-ID: | CAFj8pRDTAVfNrAzwEt+ewMfRBDZFfVa8W17Kk_E12fb6T-ZNXQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2013-01-09 08:58:24 | Re: Extra XLOG in Checkpoint for StandbySnapshot |
Previous Message | Benedikt Grundmann | 2013-01-09 08:38:25 | Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers |