Re: [GENERAL] Text value within composite function result not quoted - Mailing list pgsql-general
On May 15, 2017, at 21:36 , Tom Lane <tgl@sss.pgh.pa.us> 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.
pgsql-general by date: