postgresql - PGError : ERROR: syntax error at or near "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)