> On Oct 29, 2021, at 2:05 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > > "David G. Johnston" <david.g.johnston@xxxxxxxxx> writes: >> On Friday, October 29, 2021, Philip Semanchuk <philip@xxxxxxxxxxxxxxxxxxxxx> >> 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 quotes are getting stripped out but that is the >> issue. Maybe double them up to escape them like in a normal text literal? > > Yeah, that's just the way that \set works (and most other psql backslash > commands, I believe). You've likely got an issue with whitespace > disappearing, too, though that might be harmless in this specific example. > > regression=# \set foo 'bar baz' > regression=# \echo :foo > bar baz > regression=# \set foo 'bar ''baz' > regression=# \echo :foo > bar 'baz > regression=# \set foo bar ''baz > regression=# \echo :foo > barbaz > > Not sure offhand how well-documented this is. Thanks, all. Glad to know I wasn’t missing something obvious. > On Oct 29, 2021, at 1:52 PM, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote: > psql variables can hold only text. There is not any type - all is just text. ^^^ This was especially helpful; I’d never considered that before. Cheers Philip
