Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?

- (Negative) (SQL)

A unary operator that returns an expression as a negative, numeric value.

Synopsis

-expression

Arguments

Argument Description
expression A numeric expression.

Description

Unary operators perform an operation on only one expression of any of the data types of the numeric data type category.

– (Negative) is a Caché SQL extension.

Examples

The following example returns three numeric fields: the Age column from Sample.Person; the – (Negative) value of the average of Age; and the Age minus the average age:

SELECT Age,
       -(AVG(age)) AS NegAvg,
       Age-AVG(Age) AS AgeRelAvg
FROM Sample.Person

See Also

+ (Positive)

Feedback