array quoting
David Garamond <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.dbdpg |
|---|---|
| Message-ID | <[email protected]> |
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