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 1hnPGu-0000Z6-Vy for pgsql-sql@arkaria.postgresql.org; Tue, 16 Jul 2019 15:21:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hnPGs-0001zl-Kc for pgsql-sql@arkaria.postgresql.org; Tue, 16 Jul 2019 15:21:38 +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 ) id 1hnPGs-0001ze-96 for pgsql-sql@lists.postgresql.org; Tue, 16 Jul 2019 15:21:38 +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 ) id 1hnPGp-0000Dq-At for pgsql-sql@lists.postgresql.org; Tue, 16 Jul 2019 15:21:36 +0000 Received: from [192.168.127.1] (port=17637 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 1hnPGm-0000zP-10; Tue, 16 Jul 2019 15:21:32 +0000 Received: from [127.0.0.1] (port=35356 helo=caithnard.riddles.org.uk) by caithnard.riddles.org.uk with esmtp (Exim 4.89 (FreeBSD)) (envelope-from ) id 1hnPGl-0000Yt-AQ; Tue, 16 Jul 2019 15:21:31 +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: <472848228.1169550.1563289333511@mail.yahoo.com> (Karen Goh's message of "Tue, 16 Jul 2019 15:02:13 +0000 (UTC)") Message-ID: <87sgr6ypvp.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> <871ryq12hp.fsf@news-spur.riddles.org.uk> <472848228.1169550.1563289333511@mail.yahoo.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (berkeley-unix) Date: Tue, 16 Jul 2019 16:21:31 +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: >> What exactly is in your Program Files? Karen> PostgreSQL which has folder named 10 and then open up you will Karen> get to see bin folder, data folder, script folder .... OK, and did you try doing "SHOW log_destination;" as a query, for example in the pgadmin4 query window? also "SHOW logging_collector;" and "SHOW data_directory;" >> If you want to pass an array value as a parameter, you can't use IN >> (x), you have to use = ANY (x) instead. Karen> Is Any (x) this format applies only to Postgresql ? scalar = ANY (arrayvalue) is a postgresql extension, yes. The SQL spec says that the syntax (col IN (1,2,3)) is equivalent to (col = ANY (VALUES (1),(2),(3))) but this doesn't allow you to pass a single array parameter for the IN list either in PostgreSQL or in standard SQL. In both PostgreSQL and standard SQL you can do: (col = ANY (select v from unnest(arrayvalue) as u(v))) but this isn't the recommended style for PostgreSQL because it is less efficient. -- Andrew (irc:RhodiumToad)