pgsql判断某个字段是否为空应该写成:select * from TABLENAME where COLUMNAME is (not) null; 转载于:https://www.cnblogs.com/fcode/archive/2011/03/10/1979857.html