Unable to use ANY(), ALL(), SOME()

Question

Has anyone seen an error like:  
Problems with function : ANY. Either the function does not exist, or there is a problem with a dependent function  
  
SELECT * FROM "mytable"."temperature" WHERE device_name <> ANY('Foo', 'Bar')  
  
Edited by: dwery on Nov 22, 2020 9:50 AM

Accepted Answer

The keyword VALUES should be used if the comparison values is a list of literals e.g. SELECT * FROM "mytable"."temperature" WHERE device_name ANY(VALUES 'Foo', 'Bar'). Same for ALL and SOME too. The alternative syntax is  
SELECT * FROM "mytable"."temperature" WHERE device_name ANY (SELECT 'Foo' UNION ALL SELECT 'Bar')

Answer

VALUES worked, thank you.

Unable to use ANY(), ALL(), SOME()

Conteúdo relevante