Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1hnJEa-0002gL-JQ
	for pgsql-sql@arkaria.postgresql.org; Tue, 16 Jul 2019 08:54:52 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1hnJEZ-0002lC-Er
	for pgsql-sql@arkaria.postgresql.org; Tue, 16 Jul 2019 08:54:51 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <andrew@tao11.riddles.org.uk>)
	id 1hnJEZ-0002dq-1I
	for pgsql-sql@lists.postgresql.org; Tue, 16 Jul 2019 08:54:51 +0000
Received: from lungold.riddles.org.uk ([82.68.208.19])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.92)
	(envelope-from <andrew@tao11.riddles.org.uk>)
	id 1hnJEW-0004un-97
	for pgsql-sql@lists.postgresql.org; Tue, 16 Jul 2019 08:54:49 +0000
Received: from [192.168.127.1] (port=11461 helo=caithnard.riddles.org.uk)
	by lungold.riddles.org.uk with esmtps
 (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256)
	(Exim 4.88 (FreeBSD))
	(envelope-from <andrew@tao11.riddles.org.uk>)
	id 1hnJET-0000Mg-Ik; Tue, 16 Jul 2019 08:54:45 +0000
Received: from [127.0.0.1] (port=45573 helo=caithnard.riddles.org.uk)
	by caithnard.riddles.org.uk with esmtp (Exim 4.89 (FreeBSD))
	(envelope-from <andrew@tao11.riddles.org.uk>)
	id 1hnJES-0000LT-U1; Tue, 16 Jul 2019 08:54:45 +0000
From: Andrew Gierth <andrew@tao11.riddles.org.uk>
To: Karen Goh <karenworld@yahoo.com>
Cc: <pgsql-sql@lists.postgresql.org>
Subject: Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR:
 operator does not exist: text = integer?
In-Reply-To: <59735533.1068095.1563265280844@mail.yahoo.com> (Karen Goh's
	message of "Tue, 16 Jul 2019 08:21:20 +0000 (UTC)")
Message-ID: <87o91u1idu.fsf@news-spur.riddles.org.uk>
References: <110414461.528890.1563075361778@mail.yahoo.com>
	<1846547624.530883.1563075598322@mail.yahoo.com>
	<CAKFQuwaLmrFiSAOjzcK2-43F-016CZhP5iRpnyzJ0PzsKEgzog@mail.gmail.com>
	<40544440.741577.1563178850210@mail.yahoo.com>
	<CAKFQuwYJsFw9p_qLyashvUmONFZre9OxgEWxDkqdY6-gWB9G7A@mail.gmail.com>
	<768811852.1032981.1563242356010@mail.yahoo.com>
	<CAKFQuwaC_Z24XxjvsSgYPvSNpu+K1Z9_60auVxEpjFQpE5zrFg@mail.gmail.com>
	<774271584.1091322.1563257675315@mail.yahoo.com>
	<1984680550.1098414.1563257845450@mail.yahoo.com>
	<f11f7f05-e3fc-2794-e4ec-4b7144ae56be@stb-datenservice.de>
	<59735533.1068095.1563265280844@mail.yahoo.com>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (berkeley-unix)
Date: Tue, 16 Jul 2019 09:54:44 +0100
MIME-Version: 1.0
Content-Type: text/plain
List-Id: <pgsql-sql.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-sql@lists.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-sql>
Precedence: bulk

>>>>> "Karen" == Karen Goh <karenworld@yahoo.com> writes:

 Karen> Can I know which forum to post to cos I think this may be the
 Karen> wrong forum.

This is good enough (though the -general list would probably be better).

But you still need to show us the actual SQL text that gets sent to the
server, NOT just the java code that generates that SQL. You can get the
statement from the server logs (by default, the statement text is logged
alongside any error).

Please at least make some effort to do that before asking again.

-- 
Andrew (irc:RhodiumToad)