[GENERAL] ERROR: operator does not exist: integer = character varying

Hi! I have the following piece of jdbc code String query = "UPDATE books SET title = ? WHERE book_id=?"; pstmt =conn.prepareStatement(query); pstmt.setInt(1, new_book_id); pstmt.setString(2, getStringPrompt("new title")); pstmt.executeUpdate(); getStringPrompt returns a string and new_book_id i

[GENERAL] query problems

he problem then I'm open to suggestions. regards Andreas Berglund -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general