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
|
Список | pgsql-general |
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 по дате отправления: