Is it possible to convert a character field in PostgreSQL to integer in JPA named query?

Question

@Table(name = "Table")
class Table{
 String a
 Integer b
}

here column a in table t is character varying(32)

I have tried both of these and end-up with error.

SELECT t.b from Table t where Integer.parseInt(t.a) > 0 
Error : Caused by: org.postgresql.util.PSQLException: ERROR: schema "integer" does not exist

SELECT t.b from Table t where (t.a::integer) > 0 
Error : invalid token :: at line <line number>

Thanks

Your first solution is getting further, PostgreSQL is refusing it because it doesn't understand Integer.parseInt. I'm surprised your second solution is not working. Could you try SELECT t.b FROM table t WHERE CAST(t.a AS integer) > 0? — Daniel Lyons
– Daniel Lyons, Commented Feb 1, 2012 at 5:26

oers · Accepted Answer · 2012-02-02 09:57:45Z

4

The following query works fine for me.

SELECT t.b FROM table t WHERE CAST(t.a AS integer) > 0

oers

18.8k13 gold badges68 silver badges76 bronze badges

answered Feb 2, 2012 at 5:38

Leejoy

1,4565 gold badges25 silver badges37 bronze badges

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

1 Comment

Thank you @Daniel Lyons for this answer.