[teiid-issues] [JBoss JIRA] (TEIID-2159) Provide language objects to produce a JSON document
[
https://issues.jboss.org/browse/TEIID-2159?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-2159:
----------------------------------
Fix Version/s: 8.3
Affects: Documentation (Ref Guide, User Guide, etc.),Release Notes
pg distills this a little more -
http://www.postgresql.org/docs/devel/static/functions-json.html
It seems best to add a json type so that we are validating.
JsonParse/JsonSerialize (if we want to support other encodings / pretty print options)
JsonObject (basically the same as pg row_to_json)
JsonArray
JsonAgg (necessary since we lack formal array support)
Provide language objects to produce a JSON document
---------------------------------------------------
Key: TEIID-2159
URL: https://issues.jboss.org/browse/TEIID-2159
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Reporter: Ramesh Reddy
Assignee: Steven Hawkins
Fix For: 8.3
SQLXML is standard that lets users define XML constructs to define a XML documents using
SQL. However there is such standard exists for producing the JSON based documents.
It would be nice if Teiid provides such SQL language extensions produce and deal with
JSON documents. The constructs equivalent from SQLXML are
JsonParse
JsonObject
JsonArray
JsonForrest
JsonAgg
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira