Skip site navigation (1) Skip section navigation (2)

inconsistent behave of boolean based domains in XML functions

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers

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;

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

Best regards

Pavel Stehule

pgsql-hackers by date

Next:From: Andres FreundDate: 2013-01-09 08:58:24
Subject: Re: Extra XLOG in Checkpoint for StandbySnapshot
Previous:From: Benedikt GrundmannDate: 2013-01-09 08:38:25
Subject: Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group