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 "Mamta A. Satoor (JIRA)" <ji...@apache.org> on 2008/04/23 07:55:25 UTC

[jira] Created: (DERBY-3640) Add an example for table function in Derby Reference Manual

Add an example for table function in Derby Reference Manual
-----------------------------------------------------------

                 Key: DERBY-3640
                 URL: https://issues.apache.org/jira/browse/DERBY-3640
             Project: Derby
          Issue Type: Task
          Components: Documentation
    Affects Versions: 10.4.1.3
            Reporter: Mamta A. Satoor
            Priority: Minor


Table Functions are explained in Derby Reference Manual Section CREATE FUNCTION. At the end of the section, there is an example of how to create non-table function. It will be nice to include an example for table function as well.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-3640) Add an example for table function in Derby Reference Manual

Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-3640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12591722#action_12591722 ] 

Kim Haase commented on DERBY-3640:
----------------------------------

There are table function examples in the Developer's Guide section on programming table functions, to which this topic contains a reference. I think it helps to have that entire context. Would an additional example in this section of the Ref Manual be helpful?

> Add an example for table function in Derby Reference Manual
> -----------------------------------------------------------
>
>                 Key: DERBY-3640
>                 URL: https://issues.apache.org/jira/browse/DERBY-3640
>             Project: Derby
>          Issue Type: Task
>          Components: Documentation
>    Affects Versions: 10.4.1.3
>            Reporter: Mamta A. Satoor
>            Priority: Minor
>
> Table Functions are explained in Derby Reference Manual Section CREATE FUNCTION. At the end of the section, there is an example of how to create non-table function. It will be nice to include an example for table function as well.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Resolved: (DERBY-3640) Add an example for table function in Derby Reference Manual

Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3640?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rick Hillegas resolved DERBY-3640.
----------------------------------

    Resolution: Fixed

> Add an example for table function in Derby Reference Manual
> -----------------------------------------------------------
>
>                 Key: DERBY-3640
>                 URL: https://issues.apache.org/jira/browse/DERBY-3640
>             Project: Derby
>          Issue Type: Task
>          Components: Documentation
>    Affects Versions: 10.4.1.3
>            Reporter: Mamta A. Satoor
>            Priority: Minor
>         Attachments: derby-3640-01-tableFunctionExample.diff, rrefcreatefunctionstatement.html
>
>
> Table Functions are explained in Derby Reference Manual Section CREATE FUNCTION. At the end of the section, there is an example of how to create a scalar function. It will be nice to include an example for table function as well.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-3640) Add an example for table function in Derby Reference Manual

Posted by "Mamta A. Satoor (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-3640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12591724#action_12591724 ] 

Mamta A. Satoor commented on DERBY-3640:
----------------------------------------

I think it will be good to have an example in Reference Manual where the CREATE FUNCTION syntax is described.

> Add an example for table function in Derby Reference Manual
> -----------------------------------------------------------
>
>                 Key: DERBY-3640
>                 URL: https://issues.apache.org/jira/browse/DERBY-3640
>             Project: Derby
>          Issue Type: Task
>          Components: Documentation
>    Affects Versions: 10.4.1.3
>            Reporter: Mamta A. Satoor
>            Priority: Minor
>
> Table Functions are explained in Derby Reference Manual Section CREATE FUNCTION. At the end of the section, there is an example of how to create non-table function. It will be nice to include an example for table function as well.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-3640) Add an example for table function in Derby Reference Manual

Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3640?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Myrna van Lunteren updated DERBY-3640:
--------------------------------------

    Fix Version/s: 10.4.2.0
                   10.5.0.0

> Add an example for table function in Derby Reference Manual
> -----------------------------------------------------------
>
>                 Key: DERBY-3640
>                 URL: https://issues.apache.org/jira/browse/DERBY-3640
>             Project: Derby
>          Issue Type: Task
>          Components: Documentation
>    Affects Versions: 10.4.1.3
>            Reporter: Mamta A. Satoor
>            Priority: Minor
>             Fix For: 10.4.2.0, 10.5.0.0
>
>         Attachments: derby-3640-01-tableFunctionExample.diff, rrefcreatefunctionstatement.html
>
>
> Table Functions are explained in Derby Reference Manual Section CREATE FUNCTION. At the end of the section, there is an example of how to create a scalar function. It will be nice to include an example for table function as well.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-3640) Add an example for table function in Derby Reference Manual

Posted by "Mamta A. Satoor (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3640?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mamta A. Satoor updated DERBY-3640:
-----------------------------------

    Description: Table Functions are explained in Derby Reference Manual Section CREATE FUNCTION. At the end of the section, there is an example of how to create a scalar function. It will be nice to include an example for table function as well.  (was: Table Functions are explained in Derby Reference Manual Section CREATE FUNCTION. At the end of the section, there is an example of how to create non-table function. It will be nice to include an example for table function as well.)

> Add an example for table function in Derby Reference Manual
> -----------------------------------------------------------
>
>                 Key: DERBY-3640
>                 URL: https://issues.apache.org/jira/browse/DERBY-3640
>             Project: Derby
>          Issue Type: Task
>          Components: Documentation
>    Affects Versions: 10.4.1.3
>            Reporter: Mamta A. Satoor
>            Priority: Minor
>         Attachments: derby-3640-01-tableFunctionExample.diff, rrefcreatefunctionstatement.html
>
>
> Table Functions are explained in Derby Reference Manual Section CREATE FUNCTION. At the end of the section, there is an example of how to create a scalar function. It will be nice to include an example for table function as well.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-3640) Add an example for table function in Derby Reference Manual

Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3640?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rick Hillegas updated DERBY-3640:
---------------------------------

    Attachment: rrefcreatefunctionstatement.html
                derby-3640-01-tableFunctionExample.diff

Attaching a version of the CREATE FUNCTION page which includes an example of declaring a table function. Would this be helpful?

> Add an example for table function in Derby Reference Manual
> -----------------------------------------------------------
>
>                 Key: DERBY-3640
>                 URL: https://issues.apache.org/jira/browse/DERBY-3640
>             Project: Derby
>          Issue Type: Task
>          Components: Documentation
>    Affects Versions: 10.4.1.3
>            Reporter: Mamta A. Satoor
>            Priority: Minor
>         Attachments: derby-3640-01-tableFunctionExample.diff, rrefcreatefunctionstatement.html
>
>
> Table Functions are explained in Derby Reference Manual Section CREATE FUNCTION. At the end of the section, there is an example of how to create non-table function. It will be nice to include an example for table function as well.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-3640) Add an example for table function in Derby Reference Manual

Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-3640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12591767#action_12591767 ] 

Rick Hillegas commented on DERBY-3640:
--------------------------------------

Committed derby-3640-01-tableFunction.diff to docs trunk at subversion revision 651031 and ported to 10.4 docs branch at revision 651035.

> Add an example for table function in Derby Reference Manual
> -----------------------------------------------------------
>
>                 Key: DERBY-3640
>                 URL: https://issues.apache.org/jira/browse/DERBY-3640
>             Project: Derby
>          Issue Type: Task
>          Components: Documentation
>    Affects Versions: 10.4.1.3
>            Reporter: Mamta A. Satoor
>            Priority: Minor
>         Attachments: derby-3640-01-tableFunctionExample.diff, rrefcreatefunctionstatement.html
>
>
> Table Functions are explained in Derby Reference Manual Section CREATE FUNCTION. At the end of the section, there is an example of how to create a scalar function. It will be nice to include an example for table function as well.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-3640) Add an example for table function in Derby Reference Manual

Posted by "Mamta A. Satoor (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-3640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12591757#action_12591757 ] 

Mamta A. Satoor commented on DERBY-3640:
----------------------------------------

Thanks, Rick. The example looks good.

> Add an example for table function in Derby Reference Manual
> -----------------------------------------------------------
>
>                 Key: DERBY-3640
>                 URL: https://issues.apache.org/jira/browse/DERBY-3640
>             Project: Derby
>          Issue Type: Task
>          Components: Documentation
>    Affects Versions: 10.4.1.3
>            Reporter: Mamta A. Satoor
>            Priority: Minor
>         Attachments: derby-3640-01-tableFunctionExample.diff, rrefcreatefunctionstatement.html
>
>
> Table Functions are explained in Derby Reference Manual Section CREATE FUNCTION. At the end of the section, there is an example of how to create non-table function. It will be nice to include an example for table function as well.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.