开发者

PGError: ERROR: syntax error at or near "NULL"

Can't figure out what on earth this postgresql error is talking about.

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开发者_JAVA百科 "accounts" WHERE (`checked_at` < '2011-01-18 21:52:21.607956' OR `checked_at` IS NULL)

Any ideas what that could be?


The backticks are your problem.

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


Try this:

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

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜