![]() |
SQL-J Language Reference
|
Reference Manual |
User-Defined AggregateCloudscape allows you to create your own aggregate functions. After you create the Java classes that implement the aggregation and create the aggregate with the CREATE AGGREGATE statement, you can use those aggregate from within SQL-J the same way you use the built-in aggregates. The resulting data type of the user-defined aggregate function is defined by the implementing class. If you provide the correct implementation, a user-defined aggregate can return any built-in type or any user-defined Java data type. For information about creating the Java classes that implement the aggregation, see Programming User-Defined Aggregates in the Cloudscape Developer's Guide. SyntaxAggregateName ( [ DISTINCT | ALL ] Expression ) User-Defined Aggregate Examples
-- MAXBUTONE is a user-defined aggregate |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |