2 Answers
- Newest
- Most votes
- Most comments
0
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 3 years ago
Relevant content
- Accepted Answerasked 8 months ago
- Why did my CloudWatch canary fail with the error "Node is either not visible or not an HTMLElement"?AWS OFFICIALUpdated 5 months ago
- AWS OFFICIALUpdated 3 years ago