#301 Add flag to INFORMATION_SCHEMA.ROUTINES to identify custom AGGREGATE functions

open
nobody
None
5
2014-07-18
2014-02-07
Lukas Eder
No

I can specify my own custom AGGREGATE functions using the syntax defined here:
http://hsqldb.org/doc/guide/sqlroutines-chapt.html#src_aggregate_functions

CREATE AGGREGATE FUNCTION ...

Unfortunately, there doesn't seem to be any flag in the INFORMATION_SCHEMA.ROUTINES table to recognise such functions - e.g. in jOOQ's code generator.

As a workaround, I can "parse" the ROUTINE_DEFINITION column for "AGGREGATE FUNCTION"

Discussion

  • Fred Toussi
    Fred Toussi
    2014-02-07

    This would be a good idea. I need to figure out how to add this as the ROUTINES view is defined by the SQL Standard.

     
  • Lukas Eder
    Lukas Eder
    2014-02-07

    I hadn't seen any columns in the SQL standard 2011 draft document. But then again, custom aggregate functions aren't really part of the standard either, I think?