ALTER ANALYTIC FUNCTION

Alters a user-defined analytic function.

Syntax

ALTER ANALYTIC FUNCTION [[db-name.]schema.]function-name( [ parameter-list ] ) {
    OWNER TO new-owner
    | RENAME TO new-name
    | SET FENCED boolean-expr
    | SET SCHEMA new-schema
}

Parameters

[db-name.]schema

Database and schema. The default schema is public. If you specify a database, it must be the current database.

function-name

Name of the function to alter.

parameter-list

Comma-delimited list of parameters that are defined for this function. If none, specify an empty list.

Note

Vertica supports function overloading, and uses the parameter list to identify the function to alter.

OWNER TO new-owner

Transfers function ownership to another user.

RENAME TO new-name

Renames this function.

SET FENCED { true | false }

Specifies whether to enable fenced mode for this function.

SET SCHEMA new-schema

Moves the function to another schema.

Privileges

Non-superuser: USAGE on the schema and one of the following:

• Function owner

• ALTER privilege on the function

For certain operations, non-superusers must also have the following schema privileges:

See also