pgsql 现有数据拼装临时表

查询

select * from (VALUES (1,2),(3,4)) as tmp(id,info)
where tmp.id>1

####删除一小部分数据

delete from user using (values (1),(2),(3)) as tmp(id) where user.id=tmp.id;