Re: [GENERAL] Text value within composite function result not quoted

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [GENERAL] Text value within composite function result not quoted
Дата
Msg-id CAKFQuwZBciF2hTxuC6hwac4Wdg933bE+NDArVEgNA=hoycWtxg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Text value within composite function result not quoted  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Guyren Howe
Дата:
Сообщение: Re: [GENERAL] Text value within composite function result not quoted
Следующее
От: Vamsi Patchipulusu
Дата:
Сообщение: [GENERAL] Postgres intermittent connection errors: psql.bin: could not connectto server: Cannot assign requested address