Suggest A Question : : Frequently Asked Questions : : Search : : Relevant Manuals : :
PHP Questions : : Linux Questions : : MySQL Questions : :

home [ Login ]

Log In
Email
Pass

Forgot Password?
New User, Register here.

Weber Sites

PHP Code Search

Web Development Resources

PHP & MySQL Code Examples

PHP Web Logs (BLogs)

PHP & MySQL Forums

Web Development Index

Web Site Templates

Web Development Manuals

Web Site Uptime Monitor

web development content

Relevant Manuals

Metaprogramming language

Suggest your site

Forex Trading Online forex trading platform

Search Engine Optimization - search engine optimization (SEO) and advertising specialist.

More Info

PostgreSQL 7.4.2 Documentation
Prev	Fast Backward		Fast Forward	Next

ALTER AGGREGATE

Name

ALTER AGGREGATE -- change the definition of an aggregate function

Synopsis

ALTER AGGREGATE name ( type ) RENAME TO newname

Description

ALTER AGGREGATE changes the definition of an aggregate function. The only currently available functionality is to rename 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.
newname: The new name of the aggregate function.

Examples

To rename the aggregate function myavg for type integer to my_average:

ALTER AGGREGATE myavg(integer) RENAME TO my_average;

Compatibility

There is no ALTER AGGREGATE statement in the SQL standard.

Free Sample Chapters
	Deliver First Class Web Sites: 101 Essential Checklists Want to learn how to make your web sites usable and accessible? Want to ensure that your sites meet current best practice, without spending hours trawling through incomprehensible specifications and recommendations from dozens of different books, research papers, and web sites? Want to make sure that the sites you build are "right the first time," requiring no costly redevelopments?
More Sample Chapters

PHP General