root@:26257/> SELECT 3 = ALL ARRAY[3,3,3];
+------------------------+
| 3 = ALL ARRAY[3, 3, 3] |
+------------------------+
| true                   |
+------------------------+
(1 row)

Time: 1.991091ms

root@:26257/> SELECT 3 = ALL ARRAY[3, 3, 4];
+------------------------+
| 3 = ALL ARRAY[3, 3, 4] |
+------------------------+
| false                  |
+------------------------+
(1 row)

Time: 532.323µs

root@:26257/> SELECT 3 = ALL (SELECT 3);
pq: unsupported comparison operator: 3 = ALL (SELECT 3): op ALL array requires array on right side
root@:26257/> SELECT 3 = ANY (SELECT 3);
pq: unsupported comparison operator: 3 = ANY (SELECT 3): op ANY array requires array on right side