On Monday, May 15, 2017, Tom Lane <t...@sss.pgh.pa.us> wrote: > Guyren Howe <guy...@gmail.com <javascript:;>> writes: > > ... 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 > >
Right idea (same output rules), wrong link. The output is a composite, not an array. https://www.postgresql.org/docs/current/static/rowtypes.html#ROWTYPES-IO-SYNTAX David J.