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 28856.1494914312@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] Text value within composite function result not quoted  (Guyren Howe <guyren@gmail.com>)
List pgsql-general
Guyren Howe <guyren@gmail.com> writes:
> 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. 

Force-quoting the elements would not move the goalposts all that much
concerning parse-ability of composite (or array) output.  If you're
complaining about that, I strongly suspect your code also fails to cope
with embedded quotes, nested structures, and/or nulls.

You might consider expanding the query's output so that the fields are
delivered separately.

            regards, tom lane


pgsql-general by date:

Previous
From: Ken Tanzer
Date:
Subject: Re: [GENERAL] Help: Installing 9.6 breaks local connections to 9.2 onCentos 6.9
Next
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] Postgres intermittent connection errors: psql.bin:could not connect to server: Cannot assign requested address