ASCII

Push supported.

BIT_LENGTH

Push supported.

BTRIM

Push supported.

CHAR_LENGTH

Push supported.

CHARACTER_LENGTH

Push supported.

CHR

Push supported.

CONCAT

Results might differ between pushed and not pushed, even if the Ignore Trailing Space setting of the Greenplum data source is the same as that of TDV, because the Greenplum database always trims trailing spaces.

FIND

Push supported.

INITCAP

Push supported.

INSTR

Push supported.

LCASE

Push supported.

LENGTH

Push supported.

LOWER

Push supported.

LPAD

Push supported.

LTRIM

Push supported.

POSITION

Results might differ between pushed and not pushed, even if the Ignore Trailing Space setting of the Greenplum data source is the same as that of TDV, because the Greenplum database always trims trailing spaces.

REPEAT

Push supported.

REPLACE

Results might differ between pushed and not pushed, even if the Ignore Trailing Space setting of the Greenplum data source is the same as that of TDV, because the Greenplum database always trims trailing spaces.

RPAD

Push supported.

RTRIM

Push supported.

SPACE

Push supported.

STRPOS

Push supported.

SUBSTR

Push supported.

SUBSTRING

Push supported.

TO_HEX

Push supported.

TRANSLATE

Push supported.

TRIM

Push supported.

TRIM(LEADING FROM )

Push supported.

TRIM(TRAILING FROM )

Push supported.

UCASE

Push supported.

UNICHR

Push supported.

UNICODE

Push supported.

UPPER

Push supported.