Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Syntax

Result

Description

Examples

number + numbernumeric_expression + numeric_expression

number

Adds two numeric expressions.

  • @Width + @Height

  • ext@Cost + 10

number - numbernumeric_expression - numeric_expression

number

Subtracts a numeric expression from another.

  • @Width - 1.5

  • 150 - ext@Cost

number * numbernumeric_expression * numeric_expression

number

Multiplies two numeric expressions.

  • @Width * @Height

  • ext@Estimate * 1.2

number / numbernumeric_expression / numeric_expression

number

Divides a numeric expression by another.

numeric_expression % numbernumeric_expression

number

Computes the remainder of the division between two numeric expressions.

...

Syntax

Result

Description

Examples

COUNT(requirement_list)

number

SUM(number, requirementsnumeric_expression, requirement_list)

number

AVG(number, requirements)numeric_expression, requirement_list)

number

MAX(number, requirements)numeric_expression, requirement_list)

number

MIN(number, requirements)numeric_expression, requirement_list)

number

Boolean expressions

Syntax

Result

Description

Examples

NOT boolean_expression

boolean

boolean_expression AND boolean_expression

boolean

boolean_expression OR boolean_expression

boolean

  • expression = expression

  • expression == expression

boolean

  • expression != expression

  • expression <> expression

boolean

number > numbernumeric_expression > numeric_expression

boolean

number numeric_expression >= numbernumeric_expression

boolean

number < numbernumeric_expression < numeric_expression

boolean

number numeric_expression <= number numeric_expression

boolean

  • string_expression like string_expression

  • string_expression ~ string_expression

boolean

expression IS NULL

boolean

expression IS NOT NULL

boolean