Skip to main content

This is documentation for Caché and Ensemble. See the InterSystems IRIS version of this content.Opens in a new tab

Please read this important announcement about the future of Caché and Ensemble maintenanceOpens in a new tab. Contact your account team to migrate to InterSystems IRIS.

- (Negative)

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)

+ (Positive)Next section
Purpose of this instance: Draft documentation
DocReleaseID: Core2018.1.11
Content loaded from:
/staging/ce/2018.1.11/doc/cache/en-us/src/
/staging/ce/2018.1.11/doc/ensemble/en-us/src/
/staging/ce/2018.1.11/doc/isp/en-us/src/
/staging/learning/zenmojo-doc/en-us/src/
FeedbackOpens in a new tab