参考手册

参考手册

实例 PostgreSQL 使用 NOT BETWEEN 运算符实例

 
SELECT * FROM cars
WHERE year NOT BETWEEN 1970 AND 1980;        
                    

输出结果

 brand |  model  | year
-------+---------+------
 Ford  | Mustang | 1964
 Volvo | p1800   | 1968
(2 rows)