You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

SHOW CREATE AGGREGATE

Shows the function definition and other attributes for a user-defined aggregate function (UDAF).

Syntax

SHOW CREATE AGGREGATE function_name

Example

The following example demonstrates how to execute a SHOW CREATE AGGREGATE statement for a UDAF.

memsql> SHOW CREATE AGGREGATE multiply_hundred \G;
*************************** 1. row ***************************
           Aggregate: multiply_hundred
    Create Aggregate: CREATE AGGREGATE `multiply_hundred` (bigint(20) NULL) RETURNS bigint(20) NULL WITH STATE bigint(20) NULL INITIALIZE WITH multiply_hundred_init ITERATE WITH multiply_hundred_iter MERGE WITH multiply_hundred_merge TERMINATE WITH multiply_hundred_terminate;
character_set_client: utf8
collation_connection: utf8_general_ci
1 row in set (0.00 sec)

Related Topics