SnowConvert AI - PostgreSQL - Expressions¶

Description¶

An expression used to evaluate and compare each element of an array against a specified expression. (PostgreSQL Language Reference ANY & ALL (array) (https://www.postgresql.org/docs/current/functions-comparisons.html#FUNCTIONS-COMPARISONS-ANY-SOME))

Grammar Syntax¶

 expression operator ANY (array expression)
expression operator ALL (array expression)

To support this expression SnowConvert translates the <> ALL to NOT IN and the = ANY to IN

Sample Source Patterns¶

 SELECT some_column <> ALL (ARRAY[1, 2, 3]) 
FROM some_table;

SELECT *
FROM someTable
WHERE column_name = ANY (ARRAY[1, 2, 3]);

 SELECT some_column NOT IN (1, 2, 3)
FROM some_table;

SELECT *
 FROM someTable
 WHERE column_name IN (1, 2, 3);