我有一张名为"elevation"的表格,包含以下列:
- lat: 双精度浮点数 (主键)
- long: 双精度浮点数 (主键)
- value: 双精度浮点数
SELECT *
FROM elevation
WHERE (lat, long) IN ((29.42682, 81.774118), (29.63561, 81.622355))
虽然这个语法是有效的:
SELECT *
FROM elevation
WHERE (lat, long) = (29.42682, 81.774118) OR (lat, long) = (29.63561, 81.622355)
这是否意味着 IN 运算符不能用于元组?