Hi,

I will extend the XMLTEXT and XMLNODE functions with optional parameters:

XMLNODE(elementString [, attributesString [, contentString [,
indentBoolean]])

The content is indented by default if it contains a newline.

XMLTEXT(valueString [, escapeNewlineBoolean])

If enabled, newlines and linefeeds are converted to XML entities (&#).

Example:

select xmlnode('p', '', xmltext('hello
world')) a,
xmlnode('p', '', xmltext('hello
world'), false) b,
xmlnode('p', '', xmltext('hello
world', true)) c

A:
<p>
    hello
    world
</p>

B:
<p>hello
world</p>

C:
<p>hello&#xd;&#xa;world</p>

Regards,
Thomas

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to