Skip to content

Instantly share code, notes, and snippets.

@JoshSGman
JoshSGman / range_filter_error
Created July 15, 2014 21:40
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 ("bi