drop_aggregate man page on BSDOS

Man page or keyword search:  
man Server   6284 pages
apropos Keyword Search (all sections)
Output format
BSDOS logo
[printable version]

DROP AGGREGATE()		 SQL Commands		      DROP AGGREGATE()

NAME
       DROP AGGREGATE - Removes the definition of an aggregate function

SYNOPSIS
       DROP AGGREGATE name type

   INPUTS
       name   The name of an existing aggregate function.

       type   The  input  datatype  of an existing aggregate function, or * if
	      the function accepts any input type.  (Refer to  the  PostgreSQL
	      User's  Guide  for further information about data types.)	 [Com‐
	      ment: This should become a cross-reference rather than  a	 hard-
	      coded chapter number]

   OUTPUTS
       DROP   Message returned if the command is successful.

       ERROR: RemoveAggregate: aggregate 'agg' for 'type' does not exist
	      This message occurs if the aggregate function specified does not
	      exist in the database.

DESCRIPTION
       DROP AGGREGATE will remove all references to an existing aggregate def‐
       inition.	 To execute this command the current user must be the owner of
       the aggregate.

   NOTES
       Use CREATE AGGREGATE [create_aggregate(l)] to  create  aggregate	 func‐
       tions.

USAGE
       To remove the myavg aggregate for type int4:

       DROP AGGREGATE myavg int4;

COMPATIBILITY
   SQL92
       There is no DROP AGGREGATE statement in SQL92; the statement is a Post‐
       gres language extension.

SQL - Language Statements	 29 March 2001		      DROP AGGREGATE()
[top]
                             _         _         _ 
                            | |       | |       | |     
                            | |       | |       | |     
                         __ | | __ __ | | __ __ | | __  
                         \ \| |/ / \ \| |/ / \ \| |/ /  
                          \ \ / /   \ \ / /   \ \ / /   
                           \   /     \   /     \   /    
                            \_/       \_/       \_/ 
More information is available in HTML format for server BSDOS

List of man pages available for BSDOS

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net