Home | Previous Page | Next Page   Extending Operators and Built-In Functions > Built-In Functions >

Built-In Functions That You Cannot Overload

The following sections list built-in functions that you cannot overload.

Built-In Aggregates

Each aggregate function uses built-in functions to generate the aggregate result. You cannot overload a built-in aggregate function. Instead, you overload the necessary support functions. For a list of the aggregate functions and their related operator functions, refer to Overloading Operators for Built-In Aggregates.

Status Functions

You cannot overload the following functions that describe time, date, the database server, and the user.

cardinality() day() month() user
current dbinfo() sitename weekday()
date() dbservername today year()
datetime() mdy() trim()

Tip:
Technically, CURRENT, DBSERVERNAME, SITENAME, TODAY, and USER, are not built-in functions, but built-in macros. You can register overloaded routines by those names, but you cannot use them in SQL statements.

Optical Subsystem Functions

The following table lists the built-in functions for the Optical Subsystem that you cannot overload.

descr() volume() family()
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]