Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Caché & Ensemble 2018.1.3 — 2018.1.4 > Caché Development References > Caché SQL Reference > SQL Unary Operators > - (Negative)
Next section

- (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
Copy code to clipboard

See Also

+ (Positive)

+ (Positive)Next section