Re: [GENERAL] Text value within composite function result not quoted - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] Text value within composite function result not quoted
Date
Msg-id 25719.1494909381@sss.pgh.pa.us
Whole thread Raw
In response to [GENERAL] Text value within composite function result not quoted  (Guyren Howe <guyren@gmail.com>)
Responses Re: [GENERAL] Text value within composite function result not quoted
Re: [GENERAL] Text value within composite function result not quoted
List pgsql-general
Guyren Howe <guyren@gmail.com> 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
valuethat 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

            regards, tom lane


pgsql-general by date:

Previous
From: Guyren Howe
Date:
Subject: [GENERAL] Text value within composite function result not quoted
Next
From: Guyren Howe
Date:
Subject: Re: [GENERAL] Text value within composite function result not quoted