PGError：错误：“NULL”处或附近的语法错误

Question

无法弄清楚这个 postgresql 错误到底在说什么。

PGError: ERROR:  syntax error at or near "NULL"
LINE 1: ...at` < '2011-01-18 21:52:21.607956' OR `checked_at` IS NULL) 
                                                                 ^
: SELECT * FROM "accounts" WHERE (`checked_at` < '2011-01-18 21:52:21.607956' OR `checked_at` IS NULL)

有什么想法吗？

Answer 1

反引号是你的问题。

SELECT * FROM accounts WHERE (checked_at < '2011-01-18 21:52:21.607956' OR checked_at IS NULL)

Answer 2

试试这个：

SELECT * FROM accounts WHERE (checked_at < '2011-01-18 21:52:21.607956' OR checked_at IS NULL)