PostgreSQL Connector > PostgreSQL pushdown optimization > Pushdown optimization functions and operators
  

Pushdown optimization functions and operators

The following table summarizes the availability of pushdown functions in a PostgreSQL database. Columns marked with an X indicate that the function can be pushed to the PostgreSQL database by using source-side or full pushdown optimization. Columns marked with a dash (-) symbol indicate that the function cannot be pushed to the database.
Function
PostgreSQL
ABORT()
-
ABS()
X
ADD_TO_DATE()
X
AES_DECRYPT()
-
AES_ENCRYPT()
-
ASCII()
X
AVG()
X
CEIL()
X
CHOOSE()
-
CHR()
X
CHRCODE()
-
COMPRESS()
-
CONCAT()
X
COS()
X
COSH()
-
COUNT()
X
CRC32()
-
CUME()
-
DATE_COMPARE()
-
DATE_DIFF()
X
DECODE()
X
DECODE_BASE64()
-
DECOMPRESS()
-
ENCODE_BASE64()
-
EXP()
X
FIRST()
-
FLOOR()
X
FV()
-
GET_DATE_PART()
-
GREATEST()
-
IIF()
X
IN()
SF
INDEXOF()
-
INITCAP()
X
INSTR()
-
IS_DATE()
-
IS_NUMBER()
-
IS_SPACES()
-
ISNULL()
X
LAST()
-
LAST_DAY()
X
LEAST()
-
LENGTH()
X
LN()
X
LOG()
X
LOOKUP
X
LOWER()
X
LPAD()
X
LTRIM()
X
MAKE_DATE_TIME()
-
MAX()
X
MD5()
-
MEDIAN()
-
METAPHONE()
-
MIN()
X
MOD()
X
MOVINGAVG()
-
MOVINGSUM()
-
NPER()
-
PERCENTILE()
-
PMT()
-
POWER()
X
PV()
-
RAND()
-
RATE()
-
REG_EXTRACT()
-
REG_MATCH()
-
REG_REPLACE
-
REPLACECHR()
-
REPLACESTR()
-
REVERSE()
-
ROUND(DATE)
-
ROUND(NUMBER)
X
RPAD()
X
RTRIM()
X
SET_DATE_PART()
-
SIGN()
X
SIN()
X
SINH()
-
SOUNDEX()
-
SQRT()
X
STDDEV()
X
SUBSTR()
X
SUM()
X
SYSDATE()
X
SYSTIMESTAMP()
X
TAN()
X
TANH()
-
TO_BIGINT
X
TO_CHAR(DATE)
X
TO_CHAR(NUMBER)
X
TO_DATE()
X
TO_DECIMAL()
X
TO_FLOAT()
X
TO_INTEGER()
X
TRUNC(DATE)
-
TRUNC(NUMBER)
X
UPPER()
X
VARIANCE()
X
The following table lists the pushdown operators that can be used in a PostgreSQL database:
Operator
Pushdown
+
Supported
-
Supported
*
Supported
/
Supported
%
Supported
||
Supported
>
Supported
=
Supported
>=
Supported
<=
Supported
!=
Supported
AND
Supported
OR
Supported
NOT
Supported
^=
Supported