PostgreSQL 8.2.3 婺桺桺懼
劯锔媆锔媆誕嬉誕

ALTER AGGREGATE

劉䓄

ALTER AGGREGATE -- 媞櫹婔婻蕔镖庘昄䔇垔幬

臺濘

ALTER AGGREGATE name ( type [ , ... ] ) RENAME TO new_name
ALTER AGGREGATE name ( type [ , ... ] ) OWNER TO new_owner
ALTER AGGREGATE name ( type [ , ... ] ) SET SCHEMA new_schema

柟誄

ALTER AGGREGATE 櫹埻婔婻蕔镖庘昄䔇垔幬㔗

襕嘪䫘 ALTER AGGREGATE 嘹媙釂拖橬臖蕔镖庘昄㔗襕櫹埻婔婻蕔镖庘昄䔇昇嚟嘹媙釂婘桄昇嚟婪橬 CREATE 溄鍊㔗襕櫹埻欔橬蔙嘹媙釂滇桄欔橬蓐謾䔇婔婻䕘毖潡閘毖潊叻幽婫臖蓐謾媙釂婘蕔镖庘昄䔇昇嚟婪橬 CREATE 溄鍊㔗認底鍊彽嚺彽庖媞櫹臖欔橬蔙婉嚔啔傂嘘锔誺役鍴启麉傺蕔镖庘昄婉脘啔䔇庋愙㔗婉誺轙亓䫘潙埇傖䫘傂嘘桹濘傂懟敘櫹蕔镖庘昄䔇欔橬蔙㔗

埗昄

name

婔婻䯄橬䔇蕔镖庘昄䔇劉庖(埇傖橬昇嚟媞閄)

type

蕔镖庘昄淉嘩䔇埗昄䔇昄扞䌂傋襕嚘䫘婔婻镽埗昄蕔镖庘昄埇傖嘪䫘 * 傼敪膷噖昄扞䌂傋彖臘㔗

new_name

蕔镖庘昄䔇桄劉庖

new_owner

蕔镖庘昄䔇桄欔橬蔙

new_schema

蕔镖庘昄䔇桄昇嚟

冋床

檪婔婻毖埖 integer 䌂傋埗昄䔇蕔镖庘昄 myavg 麉变劉婺 my_average

ALTER AGGREGATE myavg(integer) RENAME TO my_average;

檪婔婻毖埖 integer 䌂傋埗昄䔇蕔镖庘昄 myavg 䔇欔橬蔙櫹埻婺 joe

ALTER AGGREGATE myavg(integer) OWNER TO joe;

檪婔婻毖埖 integer 䌂傋埗昄䔇蕔镖庘昄 myavg 䓂媘彄昇嚟 myschema 麯

ALTER AGGREGATE myavg(integer) SET SCHEMA myschema;

噚垹攓

SQL 湺庖麯麵澇橬 ALTER AGGREGATE 臺埖㔗

埽蓕

CREATE AGGREGATE, DROP AGGREGATE
劯锔饡釕嬉誕
ABORT婪婔亓ALTER CONVERSION