Avoid UDX name collisions with built-in functions

When you create a UDX, check the existing list of built-in (or default) functions to ensure that you choose unique names for your UDXs. Do not rely on case-sensitive letters alone to distinguish the names of your UDXs, as problems can result if the administrator changes the system case. By default, the Netezza Performance Server system converts all identifiers, such as database, table, and column names, to the default system case, which is uppercase. If you want to use mixed-case names for UDX names, you can place the name in double quotation marks when you register the UDX.

So, for example, there is a built-in function named TRUNC. You can create a UDF named trunc by using a command such as (a partial command follows for this example):

CREATE FUNCTION "trunc"(numeric(ANY)) RETURNS numeric(ANY) ...

Although the TRUNC and trunc functions are different functions in the database, this name overlap can lead to user confusion over the two similarly named functions. Both functions seem to be the same function, but they can have different definitions and purposes. Also, if the system administrator ever changes the system case to lowercase, an identifier name collision would result.