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 |

© Copyright Informatica LLC 2018, 2021