Date: Tue, 16 Jul 2019 15:44:03 +0000 (UTC)
From: Karen Goh <karenworld@yahoo.com>
To: Andrew Gierth <andrew@tao11.riddles.org.uk>
Cc: pgsql-sql@lists.postgresql.org
Message-ID: <774827472.1178535.1563291843182@mail.yahoo.com>
In-Reply-To: <87sgr6ypvp.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>
 <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>
 <87sgr6ypvp.fsf@news-spur.riddles.org.uk>
Subject: Re: how to resolve org.postgresql.util.PSQLException: ERROR:
 operator does not exist: text = integer?
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_1178534_763053165.1563291843181"
Content-Length: 3439
Precedence: bulk

------=_Part_1178534_763053165.1563291843181
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

 
On Tuesday, July 16, 2019, 11:21:47 PM GMT+8, Andrew Gierth <andrew@tao11.riddles.org.uk> wrote:


>>>>> "Karen" == Karen Goh <karenworld@yahoo.com> 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;"

Alright. Thanks. Let me try it.

>> 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.

I have been told In clause in the way to do it.
So, not sure why am I getting that error....
cos preferably not using any extension if it can be done using In clause..


-- 
Andrew (irc:RhodiumToad)


------=_Part_1178534_763053165.1563291843181
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div>                <br><br><br><br><br>On Tuesday, July 16, 2019, 11:21:4=
7 PM GMT+8, Andrew Gierth &lt;andrew@tao11.riddles.org.uk&gt; wrote:<br><br=
><br>&gt;&gt;&gt;&gt;&gt; &quot;Karen&quot; =3D=3D Karen Goh &lt;karenworld=
@yahoo.com&gt; writes:<br><br>&gt;&gt; What exactly is in your Program File=
s?<br><br>Karen&gt; PostgreSQL which has folder named 10 and then open up y=
ou will<br>Karen&gt; get to see bin folder, data folder, script folder ....=
<br><br>OK, and did you try doing &quot;SHOW log_destination;&quot; as a qu=
ery, for<br>example in the pgadmin4 query window? also &quot;SHOW logging_c=
ollector;&quot;<br>and &quot;SHOW data_directory;&quot;<br><br>Alright.  Th=
anks.  Let me try it.<br><br>&gt;&gt; If you want to pass an array value as=
 a parameter, you can&#39;t use IN<br>&gt;&gt; (x), you have to use =3D ANY=
 (x) instead.<br><br>Karen&gt; Is Any (x) this format applies only to Postg=
resql ?<br><br>scalar =3D ANY (arrayvalue)  is a postgresql extension, yes.=
<br><br>The SQL spec says that the syntax<br><br>(col IN (1,2,3))<br><br>is=
 equivalent to<br><br>(col =3D ANY (VALUES (1),(2),(3)))<br><br>but this do=
esn&#39;t allow you to pass a single array parameter for the IN<br>list eit=
her in PostgreSQL or in standard SQL. In both PostgreSQL and<br>standard SQ=
L you can do:<br><br>(col =3D ANY (select v from unnest(arrayvalue) as u(v)=
))<br><br>but this isn&#39;t the recommended style for PostgreSQL because i=
t is less<br>efficient.<br><br>I have been told In clause in the way to do =
it.<br>So, not sure why am I getting that error....<br>cos preferably not u=
sing any extension if it can be done using In clause..<br><br><br>-- <br>An=
drew (irc:RhodiumToad)<br><br><br>            </div>           =20
------=_Part_1178534_763053165.1563291843181--