Re: Text value within composite function result not quoted

Guyren Howe <guyren@xxxxxxxxx> · Mon, 15 May 2017 21:44:01 -0700

On May 15, 2017, at 21:36 , Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

... get this result:
(200,{},<body>Works!</body>)
This is the textual representation of the result I get in psql and Ruby. Note that the textual final value is not quoted.
I imagine I can work out a way to deal with this, but this is not the most felicitous way of representing a text value that I can imagine.
Note that if I add a single space after “Works!”, I get quotes around the string.

As per spec:

https://www.postgresql.org/docs/current/static/arrays.html#ARRAYS-IO

Thanks. This is… inconvenient. I see nothing about an option to force quoting of strings. Is there no such option? If not, I suggest that it would be a useful addition.