On Jul 1, 3:09 pm, [EMAIL PROTECTED] (D. Dante Lorenso) wrote:
I want to select several rows of data and have them returned in a single
record with the rows joined by a delimiter. It would be great if this
could be done in a generic way possibly using the GROUP BY like this:
I recently wrote
Berend Tober wrote:
D. Dante Lorenso wrote:
I want to select several rows of data and have them returned in a
single record with the rows joined by a delimiter.
Review the User Comments at
http://www.postgresql.org/docs/8.0/interactive/sql-createaggregate.html;
for some ideas.
I found a
I want to select several rows of data and have them returned in a single
record with the rows joined by a delimiter. It would be great if this
could be done in a generic way possibly using the GROUP BY like this:
SELECT a.id, a.name, STR_SUM(b.name, ',') AS b_names
FROM a, b
WHERE
D. Dante Lorenso wrote:
I want to select several rows of data and have them returned in a
single record with the rows joined by a delimiter.
Review the User Comments at
http://www.postgresql.org/docs/8.0/interactive/sql-createaggregate.html;
for some ideas.
D. Dante Lorenso wrote:
I want to select several rows of data and have them returned in a single
record with the rows joined by a delimiter.
I have something like that here:
http://www.designmagick.com/article/38
--
Postgresql php tutorials
http://www.designmagick.com/