You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Rick Hillegas (JIRA)" <ji...@apache.org> on 2014/02/02 22:54:08 UTC
[jira] [Created] (DERBY-6467) Document context-aware table
functions.
Rick Hillegas created DERBY-6467:
------------------------------------
Summary: Document context-aware table functions.
Key: DERBY-6467
URL: https://issues.apache.org/jira/browse/DERBY-6467
Project: Derby
Issue Type: Improvement
Components: Documentation
Affects Versions: 10.11.0.0
Reporter: Rick Hillegas
Now that we have added AwareVTI and VTIContext to the public api, it would be good to document how to use them. Perhaps we could add a "Writing a context-aware table function" subtopic under the "Programming Derby-style table functions" topic in the Developer's Guide.
As an example, the new subsection could use ArchiveVTI together with the script which is part of the 2014-02-02 comment on DERBY-6117.
Context-aware table functions are useful when you need to describe a family of results which have the following properties:
1) Each result in the family has a shape which is determined by a different table.
2) There may be several results associated with a given table. In addition to having the same shape, the sub-family of results differ from one another based on some variables which cannot be represented as ? parameters in a SELECT statement.
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)