pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-hackers@postgresql.org
Subject: Re: PostgreSQL vs SQL/XML Standards
Date: Mon, 29 Oct 2018 03:40:49 -0700 (MST)
Message-ID: <1540809649878-0.post@n3.nabble.com> (raw)
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>

>> 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




view thread (88+ messages)  latest in thread

Message-ID: <1540809649878-0.post@n3.nabble.com>
Permalink:  ../1540809649878-0.post@n3.nabble.com/
Also on:    postgresql.org/message-id/1540809649878-0.post@n3.nabble.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: spam_eater@gmx.net
  Subject: Re: PostgreSQL vs SQL/XML Standards
  In-Reply-To: <1540809649878-0.post@n3.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox