Details

    • Sprint:
      10.3.1-1

      Description

      With CREATE FUNCTION one can create functions in SQL, but this syntax doesn't allow one to create an aggregate function (like SUM, AVG, etc). This task is to add support for aggregate stored functions.

      Syntax

      is not decided yet. SQL Standard 2003 doesn't support aggregate stored functions (may be the newer standard does). Oracle, PostgreSQL, HSQL (may be more) all implement aggregate stored functions using their own incompatible syntax extensions. SQL Server and DB2 do not support creating new aggregate stored functions in SQL.

      The syntax should at least allow for

      • the code to return the function value
      • the code to be called per row in a group, it accumulates data, does not return a value
      • storage that is preserved between calls within a group

      and possibly

      • code to invoke between groups to reset the storage
      • code to remove data from the group (useful for window functions)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                cvicentiu Vicentiu Ciorbaru
                Reporter:
                serg Sergei Golubchik
              • Votes:
                3 Vote for this issue
                Watchers:
                10 Start watching this issue

                Dates

                • Created:
                  Updated: