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

From David G. Johnston
Subject Re: [GENERAL] Text value within composite function result not quoted
Date
Msg-id CAKFQuwZBciF2hTxuC6hwac4Wdg933bE+NDArVEgNA=hoycWtxg@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Text value within composite function result not quoted  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Monday, May 15, 2017, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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 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.


David J.

pgsql-general by date:

Previous
From: Guyren Howe
Date:
Subject: Re: [GENERAL] Text value within composite function result not quoted
Next
From: Vamsi Patchipulusu
Date:
Subject: [GENERAL] Postgres intermittent connection errors: psql.bin: could not connectto server: Cannot assign requested address