NAME

DROP AGGREGATE - 刪除一個用戶定義的聚集函數(shù)

SYNOPSIS

DROP AGGREGATE name ( type ) [ CASCADE | RESTRICT ]

DESCRIPTION 描述

DROP AGGREGATE 將刪除一個現(xiàn)存聚集函數(shù)。 執(zhí)行這條命令的用戶必須是該聚集函數(shù)的所有者。  

PARAMETERS 參數(shù)

name

 現(xiàn)存的聚集函數(shù)名（可以有模式修飾）。

type

 聚集函數(shù)的輸入數(shù)據(jù)類型，或者 * ，如果這個聚集函數(shù)接受任意輸入類型。

CASCADE

 自動刪除依賴于這個聚集的對象。

RESTRICT

 如果有任何依賴對象，則拒絕刪除這個聚集。這是缺省。

EXAMPLES 例子

 將類型 integer 的聚集函數(shù) myavg 刪除：

DROP AGGREGATE myavg(integer);

COMPATIBILITY 兼容性

 在 SQL 標(biāo)準(zhǔn)中沒有 DROP AGGREGATE 語句。  

SEE ALSO 參見

ALTER AGGREGATE [alter_aggregate(7)], CREATE AGGREGATE [create_aggregate(l)]

#p#

NAME

DROP AGGREGATE - remove an aggregate function

SYNOPSIS

DROP AGGREGATE name ( type ) [ CASCADE | RESTRICT ]

DESCRIPTION

DROP AGGREGATE will delete an existing aggregate function. To execute this command the current user must be the owner of the aggregate function.  

PARAMETERS

name

The name (optionally schema-qualified) of an existing aggregate function.

type

The argument data type of the aggregate function, or * if the function accepts any data type.

CASCADE

Automatically drop objects that depend on the aggregate function.

RESTRICT

Refuse to drop the aggregate function if any objects depend on it. This is the default.

EXAMPLES

To remove the aggregate function myavg for type integer:

DROP AGGREGATE myavg(integer);

COMPATIBILITY

There is no DROP AGGREGATE statement in the SQL standard.  

SEE ALSO

ALTER AGGREGATE [alter_aggregate(7)], CREATE AGGREGATE [create_aggregate(l)]