It seems that
- character strings must be single quoted and not double quoted.
- names that are not to be automatically upper cased are to be double
quoted and not other sorts of quotes.
- back quotes do not preserve case
1. Is that right and is that the intended way that H2 works?
select xmltext('test') "xml"
xml
1 test
select xmltext('test') `xml`
XML
1 test
2. where are these rules stated in the documentation?
3. A case sensitive mode would be nice (wish list). Also would it be
feasible to use single or double quotes interchangeably rather than
have each only work for certain situations?
--
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.
