Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?

Karen Goh <[email protected]> Tue, 16 Jul 2019 06:14:35 +0000 (UTC)
Newsgroups gmane.comp.db.postgresql.sql
Message-ID <[email protected]>
Attn to all:
For sone kind of strange reason I do not know why the mail is not sent to all.
I have normally wrote n replied to the last person who wrote but yahoo mail didn’t let me write at there.
Hope everyone receives this mail this time round.
N please help me.
Tks!



Sent from Yahoo Mail for iPhone


Begin forwarded message:

On Tuesday, July 16, 2019, 1:01 PM, David G. Johnston <[email protected]> wrote:

On Mon, Jul 15, 2019 at 6:59 PM Karen Goh <[email protected]> wrote:


May I know why did you say I am comparing subject_name to an integer ?

 I am trying to get both tutor_id and subject_name from the same table based on the no of ? in subjectName as per parameterValues.


Again, you need to send messages to the mailing, not me personally.
That said you might want to first figure out what:
ps2.setInt(1, tutor_id); 

is supposed to accomplish in your code.
David J.