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 1hnORm-00073S-31 for pgsql-sql@arkaria.postgresql.org; Tue, 16 Jul 2019 14:28:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hnORk-0008Rw-P1 for pgsql-sql@arkaria.postgresql.org; Tue, 16 Jul 2019 14:28:48 +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 1hnORk-0008Qy-Fe for pgsql-sql@lists.postgresql.org; Tue, 16 Jul 2019 14:28:48 +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 1hnORi-0003gE-8H for pgsql-sql@lists.postgresql.org; Tue, 16 Jul 2019 14:28:48 +0000 Received: from [192.168.127.1] (port=25258 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 1hnORg-0000uc-Lm; Tue, 16 Jul 2019 14:28:44 +0000 Received: from [127.0.0.1] (port=30082 helo=caithnard.riddles.org.uk) by caithnard.riddles.org.uk with esmtp (Exim 4.89 (FreeBSD)) (envelope-from ) id 1hnORg-0000Wc-11; Tue, 16 Jul 2019 14:28:44 +0000 From: Andrew Gierth To: Karen Goh Cc: pgsql-sql@lists.postgresql.org Subject: Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? In-Reply-To: <274777029.1154161.1563286780671@mail.yahoo.com> (Karen Goh's message of "Tue, 16 Jul 2019 14:19:40 +0000 (UTC)") Message-ID: <871ryq12hp.fsf@news-spur.riddles.org.uk> References: <110414461.528890.1563075361778@mail.yahoo.com> <1846547624.530883.1563075598322@mail.yahoo.com> <40544440.741577.1563178850210@mail.yahoo.com> <768811852.1032981.1563242356010@mail.yahoo.com> <774271584.1091322.1563257675315@mail.yahoo.com> <1984680550.1098414.1563257845450@mail.yahoo.com> <59735533.1068095.1563265280844@mail.yahoo.com> <87o91u1idu.fsf@news-spur.riddles.org.uk> <1919398337.1106688.1563269115584@mail.yahoo.com> <87k1ci1g9u.fsf@news-spur.riddles.org.uk> <2066139407.1119562.1563270535921@mail.yahoo.com> <87d0ia1bmt.fsf@news-spur.riddles.org.uk> <1787690642.1167081.1563281149734@mail.yahoo.com> <875zo213dq.fsf@news-spur.riddles.org.uk> <274777029.1154161.1563286780671@mail.yahoo.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (berkeley-unix) Date: Tue, 16 Jul 2019 15:28:43 +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> Yes. I have downloaded and it is inside my Program Files. What exactly is in your Program Files? Karen> And now I am getting another error : Karen> org.postgresql.util.PSQLException: ERROR: operator does not exist: text = character varying[] Someone just asked this a few minutes ago on the IRC channel but left without acknowledging my response; was that you? Karen> But, I check stackoverflow, it is mentioned that text is the Karen> best definition. And this is what I used for subject_name which Karen> is a list I am getting from the In clause. character varying[] means _array of varchar_, of course you can't compare an array directly against a scalar. If you want to pass an array value as a parameter, you can't use IN (x), you have to use = ANY (x) instead. -- Andrew (irc:RhodiumToad)