By using AWS re:Post, you agree to the Terms of Use

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


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

asked 2 years ago7 views
2 Answers
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')

answered 2 years ago

VALUES worked, thank you.

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions