Compatibility of Expressions

This table describes the compatibility of expressions between Adaptive Server Enterprise and Sybase IQ.

This table is a guide only, and a marking of Both may not mean that the expression performs in an identical manner for all purposes under all circumstances. For detailed descriptions, see the Adaptive Server Enterprise documentation and the Sybase IQ documentation on the individual expression.

In this table, expr represents an expression, and op represents an operator.

Compatibility of expressions between Adaptive Server Enterprise and Sybase IQ

Expression

Supported by

constant

Both

column name

Both

variable name

Both

function ( expr )

Both

- expr

Both

expr op expr

Both

( expr )

Both

( subquery )

Both

if-expression

Sybase IQ only