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 ) id 1hmZaK-0002Dd-1O for pgsql-sql@arkaria.postgresql.org; Sun, 14 Jul 2019 08:10:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hmZaH-0005Np-3e for pgsql-sql@arkaria.postgresql.org; Sun, 14 Jul 2019 08:10:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hmZaG-0005Ni-RF for pgsql-sql@lists.postgresql.org; Sun, 14 Jul 2019 08:10:12 +0000 Received: from lungold.riddles.org.uk ([82.68.208.19]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hmZa9-0004Yu-Lz for pgsql-sql@lists.postgresql.org; Sun, 14 Jul 2019 08:10:11 +0000 Received: from [192.168.127.1] (port=29343 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 ) id 1hmZa6-0005jv-SU; Sun, 14 Jul 2019 08:10:02 +0000 Received: from [127.0.0.1] (port=45173 helo=caithnard.riddles.org.uk) by caithnard.riddles.org.uk with esmtp (Exim 4.89 (FreeBSD)) (envelope-from ) id 1hmZa6-0002Vm-3F; Sun, 14 Jul 2019 08:10:02 +0000 From: Andrew Gierth To: Karen Goh 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: <1846547624.530883.1563075598322@mail.yahoo.com> (Karen Goh's message of "Sun, 14 Jul 2019 03:39:58 +0000 (UTC)") Message-ID: <87pnmdniry.fsf@news-spur.riddles.org.uk> References: <110414461.528890.1563075361778@mail.yahoo.com> <1846547624.530883.1563075598322@mail.yahoo.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (berkeley-unix) Date: Sun, 14 Jul 2019 09:10:01 +0100 MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk >>>>> "Karen" == Karen Goh writes: Karen> This is a continuation of my last problem - not sure if I should Karen> write from there cos the first part was solved with the help Karen> from this group. Karen> I was trying to get the matching tutor_id with the parameter Karen> values which is in this case subject_names from a table which Karen> contains both the tutor_id and the subject_names. Karen> Here's the error message: When you post these questions, you really need to include the ACTUAL SQL TEXT of the query, not just the code snippet that constructs the query (because that way we can't see for sure what query actually got constructed). The best place to find that is in the postgresql server's own logs. I would guess that the problem is that you're passing an integer parameter where you ought to be passing a string. -- Andrew (irc:RhodiumToad)