Postgres query must be of type boolean

Question

I am using skife to help with my database queries. I have the query and method below.

@SqlQuery("select * from profile where profile_id >= :from and profile_id < :to")
List<Profile> findAllInRange(@Bind("from")int from, @Bind("to")int to);

I get the following error

org.postgresql.util.PSQLException: ERROR: argument of AND must be type boolean, not type bigint

But if I execute this query

select * from profile where profile_id >= 1 and profile_id < 50

my RDBMS returns the results successfully.

What am I missing?

found the answer https://stackoverflow.com/a/19535301/5338668 — Jamal H, Jul 24 '17 at 18:36
@JamalH Because the < operator is used to bind a list of names, for example profile_id in (< list >), so is neccessary to ignore it when is not for that purpose — MinMiguelM, Jul 24 '17 at 18:36
Take a look at this sample - https://github.com/wololock/stackoverflow-answers/tree/master/45287455 I've reflected DAO and Profile entity, SQL query without escaping works like a charm. There is a test with embedded PostgreSQL added to prove it works by default. — Szymon Stepniak, Jul 24 '17 at 19:00

score 1 · Answer 1 · answered Jul 24 '17 at 18:39

1

Credit to MinMiguelM

I needed to place \\ before the < operator

answered Jul 24 '17 at 18:39

MaxPower

881
1
8
25

what is background? – Jacek Cz Aug 11 '17 at 12:14
1

Update to recent version of JDBI 2.x--this should fix the improper parsing of < and >. – qualidafial Sep 12 '17 at 00:07

Postgres query must be of type boolean

1 Answers1