PostgreSQL Connector

Back Next

SQL ELT optimization functions and operators

SQL ELT optimization
functions and operators

The following table summarizes the availability of

SQL ELT optimization

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

SQL ELT 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

SQL ELT optimization

operators that can be used in a PostgreSQL database:

Operator	SQL ELT optimization
+	Supported
-	Supported
*	Supported
/	Supported
%	Supported
\|\|	Supported
>	Supported
=	Supported
>=	Supported
<=	Supported
!=	Supported
AND	Supported
OR	Supported
NOT	Supported
^=	Supported

Rename Saved Search

Table of Contents

PostgreSQL Connector

PostgreSQL Connector

SQL ELT optimization functions and operators

SQL ELT optimization functions and operators

SQL ELT optimization
functions and operators