array_accum() and quoted content

Поиск
Список
Период
Сортировка
Искать
От
Raymond C. Rodgers
Тема
array_accum() and quoted content
Дата
Msg-id
488E143B.6050500@gmail.com
Список
Дерево обсуждения
Re: array_accum() and quoted content valgog <valgog@gmail.com>
Some time ago, I found the aggregate function array_accum() listed on 
the PostgreSQL web site on  a page similar to 
http://www.postgresql.org/docs/8.2/static/xaggr.html , and implemented 
it in a database that hasn't seen much use. More recently, for a client, 
I again used the function but I'm running into some inconsistencies 
within a select query in which I'm using the aggregate. The problem is 
that sometimes the data contained in the array is quoted, and other 
times it isn't, all within the same query results. My returned data may 
appear like this:

accumed_column
============
{"test 1","test 2","test 3"}
{test4,test5,test6}

The only difference I can see is that the quotes don't appear when the 
values returned don't contain white space, and do when white space is 
present. Is there any way to force consistency? My PHP code currently is 
expecting quoted strings to be returned.

Thank you,
Raymond
В списке pgsql-general по дате отправления
От: Andrew Sullivan
Дата:
От: Tom Lane
Дата:
FAQ