pgsql如何排除满足多个条件的数据

Question

有这样的一张表

是我用这个语句查出来的

select * from view_data vd
where machineid = 'Q94220204005'
and time> '2022-05-12 08:30:00'
and time<= '2022-05-13 08:30:00'
order by "time" asc

有没有办法修改一下这个语句，如果表中code为PRESSURE开头的数据value不在1～20之间就排除在外，查出所有其他数据

Answer 1

select * from
(
select * from view_data vd
where machineid = 'Q94220204005'
and time> '2022-05-12 08:30:00'
and time<= '2022-05-13 08:30:00'
) a where (code regexp '^(PRESSURE)' and value between 1 and 20 ) or code not regexp '^(PRESSURE)'