This project is archived and is in readonly mode.

#4462 ✓invalid
Trey Spiva

SQL error on Postgress

Reported by Trey Spiva | April 23rd, 2010 @ 03:11 PM

I am getting an PGError when using the following code snippet to search for all records that have an expirationDate greater than today.

campaigns = Table(:users)
campaigns.where(campaigns[:expirationDate].gt(Date.today.midnight))

According to this error it looks like the '*' is missing between the select and from.

ActionView::Template::Error (PGError: ERROR: syntax error at or near "FROM"
LINE 1: SELECT FROM "users" WHERE "users"."expiration...

                ^

: SELECT FROM "users" WHERE "users"."expirationDate" > '2010-04-22 06:00:00.000000')

Comments and changes to this ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »

<h2 style="font-size: 14px">Tickets have moved to Github</h2>

The new ticket tracker is available at <a href="https://github.com/rails/rails/issues">https://github.com/rails/rails/issues</a>

People watching this ticket

Pages