Dear all, I wonder why array[ref] quoting doesn't add enclosing single quotes, as in scalar quoting?
$ perl -MDBI -le'$dbh=DBI->connect("DBI:Pg:database=XXX", "XXX", "XXX");
print $dbh->quote(a); print $dbh->quote([a])'
'a'
{"a"}
Because in Postgres array literals must be enclosed in single quotes.
Regards,
dave
