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)