SnowConvert AI - PostgreSQL - Expressions¶

ALL & ANY array expressions¶

<> ALL & = ANY array expressions

Description¶

An expression used to evaluate and compare each element of an array against a specified expression. (PostgreSQL Language Reference ANY & ALL (array))

Grammar Syntax¶

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

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

Sample Source Patterns¶

Input Code:¶

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

SELECT *
FROM someTable
WHERE column_name = ANY (ARRAY[1, 2, 3]);
Copy
Output Code:¶
Snowflake¶
 SELECT some_column NOT IN (1, 2, 3)
FROM some_table;

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

Known Issues ¶

There are no known issues