> On Oct 29, 2021, at 2:05 PM, Tom Lane wrote:
>
> "David G. Johnston" writes:
>> On Friday, October 29, 2021, Philip Semanchuk
>> wrote:
>>> I would appreciate help with the syntax for querying an array of strings
>>> declared as a psql variable. Here's an example.
>>>
>>> \set important_d
"David G. Johnston" writes:
> On Friday, October 29, 2021, Philip Semanchuk
> wrote:
>> I would appreciate help with the syntax for querying an array of strings
>> declared as a psql variable. Here's an example.
>>
>> \set important_days ARRAY['monday', 'friday']
> Not sure why the single quote
Hi
pá 29. 10. 2021 v 19:21 odesílatel Philip Semanchuk <
phi...@americanefficient.com> napsal:
> Hi,
> I would appreciate help with the syntax for querying an array of strings
> declared as a psql variable. Here's an example.
>
> \set important_days ARRAY['monday', 'friday']
>
> select 1 where 'm
On Friday, October 29, 2021, Philip Semanchuk
wrote:
> Hi,
> I would appreciate help with the syntax for querying an array of strings
> declared as a psql variable. Here's an example.
>
> \set important_days ARRAY['monday', 'friday']
Not sure why the single quotes are getting stripped out but t
Hi,
I would appreciate help with the syntax for querying an array of strings
declared as a psql variable. Here's an example.
\set important_days ARRAY['monday', 'friday']
select 1 where 'monday' = ANY(:important_days);
ERROR: 42703: column "monday" does not exist
LINE 1: select 1 where 'monday'