Date: Mon, 29 Oct 2018 03:40:49 -0700 (MST)
From: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-hackers@postgresql.org
Message-ID: <1540809649878-0.post@n3.nabble.com>
In-Reply-To: 
 <CAFj8pRBDDj0Wh-3qrtC0J5tUB0z==AMh8jQ_DtiDvm7+NMZuOA@mail.gmail.com>
References: <22886.1540478379@sss.pgh.pa.us>
 <2a7715e1-6170-c3f6-12c7-7e5dda84cecd@anastigmatix.net>
 <20181025150849.j4py2nkqjx3cgw26@alvherre.pgsql>
 <CAFj8pRDs0F=3RxA4Q+3dAiosnEcTSGVLQqBZxXEM=DEiQb6sWw@mail.gmail.com>
 <5BD24640.50105@anastigmatix.net>
 <CAFj8pRBOS9TUM14-7_RjUj=5gJFG4O37ySUeReqZBTmnGnCCMw@mail.gmail.com>
 <5BD29725.1020603@anastigmatix.net>
 <CAFj8pRC8+oRv9nnOJRyiG=UE34zgc_HEYSxLhFb=wqJfnsEnwg@mail.gmail.com>
 <CAFj8pRCr-Bqf9FaBS72d8zQjsUc=eyGXrOkdZ2MmrjdXZ820jA@mail.gmail.com>
 <CAFj8pRBDDj0Wh-3qrtC0J5tUB0z==AMh8jQ_DtiDvm7+NMZuOA@mail.gmail.com>
Subject: Re: PostgreSQL vs SQL/XML Standards
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk

>> I have a access to too old 11.2 Oracle.  There I had to modify query
>> because there is not boolean type. I replaced bool by int, but I got a
>> error
>> ORA-19224:XPTY-004 .. expected node()*, got xs:string - it doesn't work
>> with/without string() wrappings.
>>
>The problem is in last line - the expression  "sale/@taxable = false()" is
>not valid on Oracle. Using string() wrapping is a issue, because it returns
">true", "false", but Oracle int doesn't accept it.

That line seems to be valid - but you need to pass an XMLTYPE value, not a
VARCHAR

https://dbfiddle.uk/?rdbms=oracle_11.2&fiddle=21cdf890a26e97fa8667b2d6a960bd33

As far as I can tell inside XQuery Oracle does support boolean, but not as a
return type 


--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html