Skip to content

Instantly share code, notes, and snippets.

@JoshSGman
Created July 15, 2014 21:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save JoshSGman/87891e4468cc1638c755 to your computer and use it in GitHub Desktop.
Save JoshSGman/87891e4468cc1638c755 to your computer and use it in GitHub Desktop.
range_filter_error
n_demo\":{\"gteq\":0,\"lteq\":1},\"num_r_cosponsors\":{\"gteq\":0,\"lteq\":199},\"num_d_cosponsors\":{\"gteq\":0,\"lteq\":199}}"}
User Load (0.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
(1.8ms) SELECT COUNT(*) FROM "bills" WHERE "bills"."congress" = '113' AND (prediction_demo IS NOT NULL) AND ("bills"."prediction_demo" >= 0) AND ("bills"."prediction_demo" <= 1) AND ("bills"."num_r_cosponsors" >= 0) AND ("bills"."num_r_cosponsors" <= 199) AND ("bills"."num_d_cosponsors" >= 0) AND ("bills"."num_d_cosponsors" <= 199)
PG::UndefinedFunction: ERROR: operator does not exist: character varying >= integer
LINE 1: ..._demo IS NOT NULL) AND ("bills"."prediction_demo" >= 0) AND ...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
: SELECT COUNT(*) FROM "bills" WHERE "bills"."congress" = '113' AND (prediction_demo IS NOT NULL) AND ("bills"."prediction_demo" >= 0) AND ("bills"."prediction_demo" <= 1) AND ("bills"."num_r_cosponsors" >= 0) AND ("bills"."num_r_cosponsors" <= 199) AND ("bills"."num_d_cosponsors" >= 0) AND ("bills"."num_d_cosponsors" <= 199)
Completed 500 Internal Server Error in 8ms
ActiveRecord::StatementInvalid (PG::UndefinedFunction: ERROR: operator does not exist: character varying >= integer
LINE 1: ..._demo IS NOT NULL) AND ("bills"."prediction_demo" >= 0) AND ...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
: SELECT COUNT(*) FROM "bills" WHERE "bills"."congress" = '113' AND (prediction_demo IS NOT NULL) AND ("bills"."prediction_demo" >= 0) AND ("bills"."prediction_demo" <= 1) AND ("bills"."num_r_cosponsors" >= 0) AND ("bills"."num_r_cosponsors" <= 199) AND ("bills"."num_d_cosponsors" >= 0) AND ("bills"."num_d_cosponsors" <= 199)):
app/controllers/api/base_controller.rb:19:in `with_pagination_attrs'
app/controllers/api/bills_controller.rb:23:in `index'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment