Getting a database error on a Rails query

Question

I'm getting an error on a query in PostgreSQL in a rake task I'm trying to et up.

  posts = Post.where("status IS ? AND publish_on < ?", 'queued', Time.now)

Here's the error:

PGError: ERROR:  syntax error at or near "'queued'"
    LINE 1: SELECT "posts".* FROM "posts"  WHERE (status IS 'queued' AND...
                                                            ^
    : SELECT "posts".* FROM "posts"  WHERE (status IS 'queued' AND publish_on < '2012-04-29 23:44:06.423516')

At first I thought it was the quotes, but changing them didn't work. Now I think it's probaly how I'm contstructing the and clause?

Dylan Markow · Accepted Answer · 2012-04-29 23:53:16Z

2

IS is only for comparing against TRUE, FALSE, or NULL. You probably want = instead:

posts = Post.where("status = ? AND publish_on < ?", 'queued', Time.now)

answered Apr 29, 2012 at 23:53

Dylan Markow

125k27 gold badges287 silver badges202 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting a database error on a Rails query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related