Re: psql syntax for array of strings in a variable?
От
David G. Johnston
Тема
Re: psql syntax for array of strings in a variable?
Дата
Msg-id
CAKFQuwYbiEwY0RAptgfYCKOb-fbC3Ddsph17Mnp6B==w6fRcaQ@mail.gmail.com
Ответ на
psql syntax for array of strings in a variable? (Philip Semanchuk)
Список
Дерево обсуждения
psql syntax for array of strings in a variable? Philip Semanchuk <philip@americanefficient.com>
Re: psql syntax for array of strings in a variable? Pavel Stehule <pavel.stehule@gmail.com>
Re: psql syntax for array of strings in a variable? "David G. Johnston" <david.g.johnston@gmail.com>
Re: psql syntax for array of strings in a variable? Tom Lane <tgl@sss.pgh.pa.us>
Re: psql syntax for array of strings in a variable? Philip Semanchuk <philip@americanefficient.com>
On Friday, October 29, 2021, Philip Semanchuk <philip@americanefficient.com> 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 that is the issue. Maybe double them up to escape them like in a normal text literal?
Otherwise consider just doing a comma delimited string and using string_to_array in the sql to turn it into an array at runtime.
\set important_days ARRAY['monday',
'friday']
Not with \set. You could write sql to output the text and then execute it using \gexec to store the column value in a variable. That too may be a solution to the missing single quotes.
David J.
В списке pgsql-general по дате отправления
От: Oleg Serov
Дата:
