NAME

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

SYNOPSIS

DROP AGGREGATE name ( type ) [ CASCADE | RESTRICT ]

DESCRIPTION 描述

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

PARAMETERS 參數(shù)

name

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

type

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

CASCADE

 自動(dòng)刪除依賴(lài)于這個(gè)聚集的對(duì)象。

RESTRICT

 如果有任何依賴(lài)對(duì)象，則拒絕刪除這個(gè)聚集。這是缺省。

EXAMPLES 例子

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

DROP AGGREGATE myavg(integer);

COMPATIBILITY 兼容性

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

SEE ALSO 參見(jiàn)

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)]