Re: array quoting
David Garamond <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.dbdpg |
|---|---|
| Message-ID | <[email protected]> |
On Wed, Aug 5, 2009 at 1:19 AM, Greg Sabino Mullane <greg-738XdyZ4GzZWk0Htik3J/[email protected]>wrote: > > I wonder why array[ref] quoting doesn't add enclosing single quotes, > > as in scalar quoting? > > {"a"} > > Because in Postgres array literals must be enclosed in single quotes. > > Thanks for the report. I fixed this in r13162, created ticket 48420 > to track it, and just released version 2.15.0, which has this fix. > > https://rt.cpan.org/Ticket/Display.html?id=48420 > Thanks for the prompt reply and fix! Regards, dave